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
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.