Changing the values from Indian Rupees to Dollars with correct spacing

[VDS]

When we type the numeric values upto 5 digits, Indian Rupees and USD have the same number of sequence except the symbol. But when it is more than 5 digits, then USD should be displayed like $ 123,456 and Indian Rupees should be Rs 1,23,456. But In both the cases, it is displaying the same way. I tried to change through Custom format. But not able to do this. How this can be corrected. Sample data attached.


VDS

 

[Khalid NGO]

Hi VDS,
I think you can use this for $:
[>=10000000]"$ "##\,##\,##\,##0;[>=100000]"$ " ##\,##\,##0;"$ "##,##0

and this for Rs:
[>=10000000]"RS "##\,##\,##\,##0;[>=100000]"RS " ##\,##\,##0;"RS "##,##0

Sir Hui explained in detail here:
http://chandoo.org/wp/2010/07/26/indian-currency-format-excel/

Regards,

 

[KSKwin]

Hi,

How to combine the below formulae {both positive & negative cases)

[<=-10000000]""- ##\,##\,##\,##0;[<=-100000]"" - ##\,##\,##0;" "##,##0

[>=10000000]" "##\,##\,##\,##0;[>=100000]" " ##\,##\,##0;" "##,##0

 

[Luke M]

@KSKwin

This thread is 8 years old. I suggest starting your own new thread where it will have more visibility.