Decimels conversion

[kingshuk_963]

In Excel Worksheet a figure can be written in e.g. 100,000.00, how could I
change the figure in Indian type i.e., 10,00,000.00

 

[Niek Otten]

Format Custom as

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