Home > front end >  EXCEL - format cells to make negative numbers red and show them with persian numerals
EXCEL - format cells to make negative numbers red and show them with persian numerals

Time:01-18

I'm not familiar with excel formats but I've found these two formats and I need to combine them to have a result of comma separated Persian numbers which negative values are red,

to make negative numbers comma separated and show negative values in red :

#,##0_ ;[Red]-#,##0 

to show numbers with Persian/Arabic numerals:

[$-2060000]

any help would be appreciated

CodePudding user response:

Try using conditional formatting as a workaround. Red font when <0.

  •  Tags:  
  • Related