Getting started

Lakh and crore number format in expense apps and spreadsheets

Want amounts shown as 12,34,567 instead of 1,234,567? How to check an expense app for lakh and crore grouping and set it in Excel or Google Sheets.

Editorial illustration for Lakh and crore number format in expense apps and spreadsheets

Indian digit grouping writes 12,34,567 with the first comma after three digits and every comma after that after two. Before you adopt an expense app, test that it shows this format; if it does not, a spreadsheet custom format can show it. Both checks take a few minutes.

Why does the format matter?

Large amounts are easier to read in the style you use every day. Compare 1234567 with 12,34,567 and with 1,234,567. The last is the international style: same number, different commas. Misreading it by a place is easy when you are scanning a long list of rent, EMI and savings figures.

How do I check an app before I commit?

  1. Add a test expense of 1234567 or import a row of that size.
  2. Look at the amount in the list, on the dashboard and in any report.
  3. Open a CSV download and see whether amounts are plain numbers or formatted text.
  4. Check the region or number-format settings on the phone as well, since some apps follow the device.
  5. Try an amount in the crores, such as 12,34,56,789, to see whether grouping holds.

SpendixAI does not state how it groups digits, so no claim is made either way. It lets you start on the free plan, which is a cheap way to run the test above on your own data.

How do I get lakh grouping in Excel?

Two routes. The first is the system route: set the Windows region to English (India) and Excel's standard comma format then follows Indian grouping on that computer. The second is a custom number format that works anywhere. Select the cells, open Format Cells, choose Custom and enter:

[>=10000000]##\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0

This three-part format uses a condition for crores, then lakhs, then everything smaller. It displays 12345678 as 1,23,45,678 and 1234567 as 12,34,567. Test it on a few values before you rely on it, because Excel versions can differ in how they treat conditions.

What about Google Sheets?

Open Format, then Number, then Custom number format, and paste the same string. Sheets accepts conditions in square brackets, so it should behave the same way. Negative amounts need extra care: the format above handles positives, so for refunds you may prefer a separate column or a second format that starts with a minus condition.

A worked example with made-up numbers

Raw numberInternational styleIndian style
8500085,00085,000
12345671,234,56712,34,567
1234567812,345,6781,23,45,678
123456789123,456,78912,34,56,789

Notice that anything below one lakh looks the same in both. The two diverge from 1,00,000 onward, which is why a small test amount will not tell you anything. Always test with at least seven digits.

Does the phone or computer setting matter?

It can. Many apps and spreadsheets take their number style from the device region. If you see international grouping on a new phone, check the region and number-format settings in the system menu before blaming the app. Also check how a CSV opened on another computer looks, because the same file can show different grouping on a machine with different regional settings, even though the stored numbers are identical.

What about words such as lakh in reports?

Some people prefer to see 12.5 lakh rather than 12,50,000 in summaries. In a sheet you can divide by 100000 and add a label: =B2/100000 with the header Amount in lakh. For crore, divide by 10000000. Say a yearly total is 12,50,000: dividing by 100000 gives 12.5. Keep the raw column nearby so nothing gets lost in rounding.

Checklist

  • Test amounts of one lakh, ten lakh and one crore entered.
  • Dashboard, list and report all checked.
  • CSV download opened in a spreadsheet.
  • Custom format applied if the app falls short.
  • Negative amounts and decimals tried.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports