I’m using Google Sheets for work and need to show numbers in the Indian Lakh and Crore format. My team finds it easier to read.
For example:
- 150000 should look like 1,50,000
- 12000000 should look like 1,20,00,000
I tried setting a custom format like ##,##,##,000 but it didn’t work. The numbers still show up in the standard format (like 12,000,000).
I checked the help docs but couldn’t find anything about this. Is there a way to make Google Sheets use the Indian number format? It would really help avoid mix-ups in our reports.
Has anyone figured out how to do this? Any tips or tricks would be great. Thanks!
I’ve experimented with handling numbers in the Indian formatting style within Google Sheets, and although there isn’t a built-in option, a workaround has worked well for me. In my experience, using a formula with the TEXT function can effectively simulate lakhs and crores formatting. For example, a formula like =TEXT(A1, “[>9999999]##,##,##,##0;[>99999]##,##,##0;##,##0”) in a helper cell transforms a number like 12000000 into 1,20,00,000. It’s not perfect and might require some adjustments for specific datasets, but it reliably improves the readability of financial reports.
hey, i found a neat trick for this! go to Format > Number > More formats > More currencies. then pick Indian rupee. it’ll format ur numbers like 1,50,000 for lakhs. not perfect for crores, but its a quick fix. hope this helps!
As someone who frequently works with international financial data, I’ve encountered this issue before. Unfortunately, Google Sheets doesn’t natively support the Indian numbering system. However, I’ve found a reliable solution using custom number formatting. Try this custom format: [>9999999]##,##,##,##0;[>99999]##,##,##0;##,##0
To apply it, select your cells, go to Format > Number > More formats > Custom number format. Paste the above code. This should format your numbers correctly for lakhs and crores. It’s not perfect for all scenarios, but it works well for most common financial figures. Remember to double-check your results, especially with very large numbers.