Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Applying Indian comma style
Hi Everybody,
Can anyone tell me how to apply the comma format to numeric cells in Indian style i.e., - In excel the default format is 1,000,000,000,000. In this style there is a comma after every three digits - In India we use slightly different format initially a comma after three digits (from right side), and then a comma after every two digits. The same above number can be written in Indian style as follows: 10,00,00,00,00,000 How to apply this format. I am using Win-95. Thanks in advance NAVEEN |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Applying Indian comma style
Use a custom format of
[=10000000]##\,##\,##\,##0;[=100000]##\,##\,##0;##,##0 -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "NAVEEN" wrote in message ... Hi Everybody, Can anyone tell me how to apply the comma format to numeric cells in Indian style i.e., - In excel the default format is 1,000,000,000,000. In this style there is a comma after every three digits - In India we use slightly different format initially a comma after three digits (from right side), and then a comma after every two digits. The same above number can be written in Indian style as follows: 10,00,00,00,00,000 How to apply this format. I am using Win-95. Thanks in advance NAVEEN |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commas in indian style | Excel Worksheet Functions | |||
Comma separator for custom Currency (Indian Rupee) | Excel Discussion (Misc queries) | |||
Currency, Percent and Comma Style buttons | Excel Worksheet Functions | |||
thousand separator as indian style for negative number | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) |