Applying Indian comma style

N

NAVEEN

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
 
B

Bob Phillips

Use a custom format of

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top