Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Req help on Formula or vb in excel to calculate between reference style and formula style tia sal2 | Excel Discussion (Misc queries) | |||
comma in indian style | Excel Discussion (Misc queries) | |||
Applying Indian comma style | Excel Discussion (Misc queries) | |||
Currency, Percent and Comma Style buttons | Excel Worksheet Functions | |||
India comma style in negative but in brackets | Excel Discussion (Misc queries) |