How to change to the Indian Number System?

[nicolasontheroad]

Hello,

can anyone tell me how I can format the Excel cells in a way that the
display the number in the Indian number system?

e.g. 10.000.000 Rs in the English system but 1,00,00,000 Rs in th
Indian system

Thanks,
Ni

 

[Bob Phillips]

Create a custom number format of

=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00

This will format say 1234567890 as 123,45,67,890.00




--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[nicolasontheroad]

i have found this reply on the web in several forums already, an
unfortunately it does not work.

the sample number 24270306 (or 24.270.306 in regular format) wil
change to ,2,4.2,70.306 if the suggested custom format is applied.

suggested format:
[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00

any ideas what the problem is

 

[Bob Phillips]

Must be something to do with your regional settings, because it shows as
2,42,70,306 for me which is correct as I understand the Indian numbering
system.

Maybe you need

[>=10000000]##\.##\.##\.##0,00;[>=100000]##\.##\.##0,00;##.##0,00

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[nicolasontheroad]

hello bob,

excellent, your second suggestion worked!

there is just one little problem left: numbers below 100.000 wil
vanish from the sheet if this formula is applied. is it possible t
expand the formula, so e.g. 35.000 will be properly displayed?

meanwhile, thank you very much,
ni

 

[Bob Phillips]

It shows as 35.00 on my machine, not a problem.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)