Coma Separator in Numbers
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? |
Coma Separator in Numbers
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? |
All times are GMT +1. The time now is 12:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com