| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display the number in the Indian format
How to display a number with comma in Indian format for eg: 12,34,567.00
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display the number in the Indian format
http://exertia.wordpress.com/2006/04...ores-in-excel/
-- David Biddulph "bala" wrote in message ... How to display a number with comma in Indian format for eg: 12,34,567.00 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display the number in the Indian format
Thank you very much .... It worked finally after I tried a lot of other
methods. "David Biddulph" wrote: http://exertia.wordpress.com/2006/04...ores-in-excel/ -- David Biddulph "bala" wrote in message ... How to display a number with comma in Indian format for eg: 12,34,567.00 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display the number in the Indian format
Thx
"David Biddulph" wrote: http://exertia.wordpress.com/2006/04...ores-in-excel/ -- David Biddulph "bala" wrote in message ... How to display a number with comma in Indian format for eg: 12,34,567.00 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display the number in the Indian format
Hi,
I didn't check the link, but the quick way is to choose Tools, Options, International tab, uncheck Use system separators and replace Decimal separator with a comma and Thousands separator with a period. -- Thanks, Shane Devenshire "bala" wrote: How to display a number with comma in Indian format for eg: 12,34,567.00 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display the number in the Indian format
Hi Shane,
The problem is grouping 2 and three digits, not the separators -- Kind regards, Niek Otten Microsoft MVP - Excel "ShaneDevenshire" wrote in message ... Hi, I didn't check the link, but the quick way is to choose Tools, Options, International tab, uncheck Use system separators and replace Decimal separator with a comma and Thousands separator with a period. -- Thanks, Shane Devenshire "bala" wrote: How to display a number with comma in Indian format for eg: 12,34,567.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change to the Indian Number System? | Excel Discussion (Misc queries) | |||
| excel should allow me Indian number grouping ##,##,##,###.## | Excel Worksheet Functions | |||
| Indian Number Format - Enabling the calculation | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| Import Indian Rupees as a number format in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
