Applying Indian comma style

Hi Everybody,

Can anyone tell me how to apply the comma format to numeric cells in Indian
style

i.e.,

- In excel the default format is 1,000,000,000,000. In this style there is a
comma after every three digits

- In India we use slightly different format
initially a comma after three digits (from right side), and then a comma
after every two digits. The same above number can be written in Indian style
as follows:
10,00,00,00,00,000

How to apply this format.

I am using Win-95.

Thanks in advance

NAVEEN

Use a custom format of

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"NAVEEN" <[email protected]> wrote in message
news:[email protected]...
> Hi Everybody,
>
> Can anyone tell me how to apply the comma format to numeric cells in
Indian
> style
>
> i.e.,
>
> - In excel the default format is 1,000,000,000,000. In this style there is
a
> comma after every three digits
>
> - In India we use slightly different format
> initially a comma after three digits (from right side), and then a comma
> after every two digits. The same above number can be written in Indian
style
> as follows:
> 10,00,00,00,00,000
>
> How to apply this format.
>
> I am using Win-95.
>
> Thanks in advance
>
> NAVEEN