Anonymous User
  Friday, 05 May 2023
  0 Replies
  1.8K Visits
0
Votes
Undo
Hi,

I want to customize the formats in Indian currency format.

i am using the formula [>=100000000]" "##\,##\,##\,##\,##0;[>=100000]" " ##\,##\,##0;" "##,##0 works well for positive results.

but not for negative results (the number separator is not per Indian currency format as the minus symbol is shown with).

Required number foramts => 1,23,45,57,890 & - 1,23,45,57,890

Attached the excel for your references.

Thanks
KSK
There are no replies made for this post yet.