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?

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)

"Procash" wrote in message
...
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?