How do I show a number in the Indian format 12,34,567?

The Indian system groups the last three digits, then in pairs. Use a custom number format like [>9999999]##\,##\,##\,##0;[>99999]##\,##\,##0;##,##0, or use Tellsheet's Digit grouping mode to reformat a whole column at once.

What is a lakh and a crore?

A lakh is 100,000 (one hundred thousand) and a crore is 10,000,000 (ten million). So 1.5 million is 15 lakh, and 25 million is 2.5 crore.

Home › Excel Guides › Convert to Lakhs & Crores in Excel

How to Convert Numbers to Lakhs & Crores in Excel

Excel speaks millions and billions with 1,234,567 grouping. Indian reporting speaks lakhs and crores with 12,34,567. Here's how to switch a column of figures either way.

Last updated: August 2026

Figure		Indian
1,500,000	→	15 Lakh (or 15,00,000)
25,000,000	→	2.5 Crore (or 2,50,00,000)

A lakh, a crore — the quick maths

A lakh is 100,000 and a crore is 10,000,000. Because one million is ten lakh, a figure in millions × 10 = lakhs, and crores × 100 = millions. So 1.5 million is 15 lakh, and 25 million is 2.5 crore.

Method 1 — a custom number format (display only)

To show a value in lakhs without changing it, select the cells, press Ctrl+1, choose Custom, and enter a code such as 0.0,,"Cr" to scale down (each comma divides by a thousand). This keeps the real number for calculation but only shows the reduced figure — handy, but it doesn't handle the lakh/crore split cleanly, and copies of the cell carry the raw value.

Method 2 — a helper column

When you need the reduced figure as a real number, divide in a spare column: =A2/100000 for lakhs, =A2/10000000 for crores, then add a label with &" Lakh". Works, but it's a formula per format and you have to manage the extra column.

The one-click way — Tellsheet's India ↔ International Numbers

Select the column of figures and open India ↔ International Numbers. Pick one of three jobs:

Scale words — 1500000 → 15 Lakh, 25000000 → 2.5 Crore (or 1.5 Million / 25 Million in the international system; long words or short 15L / 2.5Cr).
Digit grouping — reformat to the Indian 12,34,567 or the international 1,234,567, value unchanged.
Restate value between units — figures stated in millions become the same figures in lakhs (×10), and back.

It runs on Excel for Windows, Mac, and the web, only touches numeric cells, and previews before anything is written.

Frequently asked questions

How do I convert millions to lakhs in Excel?

One million is ten lakh, so multiply a "in millions" figure by 10 to read it in lakhs. Tellsheet's Restate value between units mode does it in a click; or use =A2*10 in a helper column.

How do I show 12,34,567 instead of 1,234,567?

The Indian system groups the last three digits then in pairs. Use Tellsheet's Digit grouping mode to reformat a whole column, or a custom format code for display-only.

Does it change my real numbers?

Scale-words and grouping write formatted text (so "15 Lakh" is a label); restate writes a real number. Every mode previews first, and the change history lets you revert.

Related Excel guides

Lakhs and crores in one click

India ↔ International Numbers converts a whole column between lakh/crore and million/billion — scale words, Indian grouping, or a straight millions-to-lakhs restatement, previewed before it applies.

Get Tellsheet free See pricing