Format Custom as

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

--
Kind regards,

Niek Otten

"kingshuk_963" wrote in message
...
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