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

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

"kiran kumar" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| 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!!!)
|

Hi Niek

Thank you very much
thats working correctly

Warm Regards
Kiran

On Aug 20, 12:40 pm, "Niek Otten" <nicol...@xs4all.nl> wrote:
> 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
>
> "kiran kumar" <kirandixi...@gmail.com> wrote in messagenews:(E-Mail Removed)...
>
> | 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!!!)
> |