How to display Lakhs and Crores in Excel

by Sanju 2009-04-12 16:22:51

Displaying Lakhs and Crores in Excel

Here's an Excel scrap for users in India and other places that use number formats like 100,00,00,000 instead of 1,000,000,000:

You may have faced the problem of Excel always displaying amounts in millions and not in lakhs e.g. 1,000,000 instead of 10,00,000. Here's a trick to get them to display correctly:

Right-click on the cells which you want to display as lakhs, and click on Format Cells, then go to the Custom category and enter the below formats:
For Lakhs (+ve and -ve):

With 2 decimals:
[>99999]##,##,##0.00;[<-99999.99]-##,##,##0.00;##,##0.00


Without decimals:
[>99999]##,##,##0;[<-99999.99]-##,##,##0;##,##0


For Lakhs and crores (+ve)
[>9999999]##,##,##,##0.00;[>99999]##,##,##0.00;##,##0.00


For Lakhs and crores (-ve)
[<-9999999](##,##,##,##0.00);[<-99999](##,##,##0.00);##,##0.00



Tagged in:

4583
like
0
dislike
0
mail
flag

You must LOGIN to add comments