ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   10 million appears as 10,000,000.00 (https://www.excelbanter.com/excel-discussion-misc-queries/108328-10-million-appears-10-000-000-00-a.html)

ravi

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

Bob Phillips

10 million appears as 10,000,000.00
 

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





All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com