Coma Separator in Numbers

P

Procash

Excel has a Thousand coma seperator. I need the numerals to be displayed /
entered having a hundred coma seperator. (i.e.) Excel accepts and shows the
value "A hundred Million" as 100,000,000.00. I want this to be accepted and
the number shown as 10,00,00,000.00. I would like to know how do I change the
position of the Coma Seperator?
 
B

Bob Phillips

A custom number format of

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

will format say 1234567890 as 123,45,67,890.00

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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