[=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)

"ravi" <ravi @discussions.microsoft.com wrote in message
...
how to change thousand seprator in excel 2003 and 10 million appears as
10,00,000.00