Number format

[Jamal]

Is there a way to format number to show say 1,00,000 instead of 100,000. This
is to reflect Indian 100,000, which is called one lac. I am using Excel 2000.
Thanks for your help.

 

[John Bundy]

Not tested, but look here

http://www.dq.winsila.com/tips-tric...show-currency-in-indian-format-and-words.html