Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Anonymous User
  Friday, 05 May 2023
  0 Replies
  1.5K 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.