How to display a number with comma in Indian format for eg: 12,34,567.00
D David Biddulph Oct 18, 2008 #2 http://exertia.wordpress.com/2006/04/23/displaying-lakhs-and-crores-in-excel/
B bala Oct 18, 2008 #3 Thank you very much .... It worked finally after I tried a lot of other methods.
B bala Oct 18, 2008 #4 Thx David Biddulph said: http://exertia.wordpress.com/2006/04/23/displaying-lakhs-and-crores-in-excel/ Click to expand...
Thx David Biddulph said: http://exertia.wordpress.com/2006/04/23/displaying-lakhs-and-crores-in-excel/ Click to expand...
S ShaneDevenshire Oct 18, 2008 #5 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.
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.
N Niek Otten Oct 18, 2008 #6 Hi Shane, The problem is grouping 2 and three digits, not the separators