Display the number in the Indian format
 

How to display a number with comma in Indian format for eg: 12,34,567.00

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

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

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

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

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