ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   About comma style in MS Excel (https://www.excelbanter.com/excel-discussion-misc-queries/180413-about-comma-style-ms-excel.html)

Amrit

About comma style in MS Excel
 
I am using MS Office 2003. I have tried all the options to change comma
places or comma style in MS Excel to suites Indian number system but not
succeeded. I have tried (1) Control Panel's regional setting options (2) MS
Excel custom number formatting in Cell, formatting option. Please help me?

Bob Phillips

About comma style in MS Excel
 
You won't succeed, you need a custom number format


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



"Amrit" wrote in message
...
I am using MS Office 2003. I have tried all the options to change comma
places or comma style in MS Excel to suites Indian number system but not
succeeded. I have tried (1) Control Panel's regional setting options (2)
MS
Excel custom number formatting in Cell, formatting option. Please help me?





All times are GMT +1. The time now is 02:49 PM.

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