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