Applying Indian comma style

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top