Comma separator for numbers

[kiran kumar]

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!!!)

 

[Niek Otten]

Format>Cells>Number tab>Custom, in the Type box enter:

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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!!!)
|

 

[kiran kumar]

Hi Niek

Thank you very much
thats working correctly

Warm Regards
Kiran