10 million appears as 10,000,000.00

R

ravi

how to change thousand seprator in excel 2003 and 10 million appears as
10,00,000.00
 
B

Bob Phillips

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

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top