FormatCellsNumber tabCustom, in the Type box enter:

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"kiran kumar" wrote in message ups.com...
| Hi
|
| I have a issue with number formatting, in India we use thousand
| separator as below, we do not follow million style of for using commas
| instead we follow Lakhs format. I tried many permutations and
| combinations in format cells- custom formatting but I am not getting
| the desired output.
|
| 1,000
| 10,000
| 1,00,000
| 10,00,000
| 1,00,00,000
| 10,00,00,000
| .
| .
| .
| .
| .
|
| can any one help me out?
|
| Thanks in advance (b'coz I know I guys can do it!!, & in excel
| anything and everything is possible!!!)
|