Display the number in the Indian format

[bala]

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

 

[bala]

Thank you very much .... It worked finally after I tried a lot of other
methods.

 

[bala]

Thx

http://exertia.wordpress.com/2006/04/23/displaying-lakhs-and-crores-in-excel/

 

[ShaneDevenshire]

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.

 

[Niek Otten]

Hi Shane,

The problem is grouping 2 and three digits, not the separators