Indian Number Formatter
Excel, Google Sheets and most software default to the international 3-3-3 comma system (1,234,567). Indian financial statements, GST returns, bank letters and MIS reports need the 3-2-2 system (12,34,567). Converting a long column manually is tedious — paste the numbers here and get every line reformatted in one click.
What you get for each number
- Indian grouping — 1,23,45,678.90
- International grouping — 12,345,678.90
- Lakh/Crore abbreviation — 1.23 Cr, 45.6 L, 12 K
- Million/Billion abbreviation — 12.35 M, 1.2 B
Choose the number of decimals (or keep as entered), optionally prefix the ₹ symbol, and copy any column or the complete table as tab-separated text that pastes cleanly into Excel or Word. The total of all numbers is shown in each format as well.
Indian grouping rule
Place a comma after the first three digits from the right, then after every two digits: 1000 → 1,000; 100000 → 1,00,000 (one lakh); 10000000 → 1,00,00,000 (one crore). Abbreviations: 1 L = 1,00,000; 1 Cr = 100 L = 10 Million; 1 Billion = 100 Crore.
Worked example
Input 15000000000 → Indian 15,00,00,00,000; International 15,000,000,000; abbreviated 1500 Cr or 15 B.
Typical uses
- Reformatting turnover, loan or budget figures for board decks and bank CMA data.
- Converting export/import invoice values between Indian and foreign reporting styles.
- Cleaning numbers pasted from PDFs that already contain stray commas, ₹ signs or spaces — the tool strips them before formatting.
Why the two systems differ
The Indian system descends from the Vedic numbering tradition where names exist for powers of ten at 105 (lakh) and 107 (crore), so separators follow those names. The international short-scale system names every third power of ten (thousand, million, billion). Regulators in India (RBI, SEBI, MCA, GSTN) report in lakh and crore, while foreign investors, auditors of multinational subsidiaries and software defaults use million/billion — which is why finance teams constantly convert between the two.
Decimal handling
"As entered" keeps the decimals present in each line (so 4521.5 stays 4,521.5 while 250000 stays 2,50,000). Choosing a fixed number of decimals pads or rounds every line uniformly, which is what you want for a presentable column in a report.
Frequently Asked Questions
Can I paste numbers that already have commas?
Yes. Commas, spaces and ₹/$ symbols are removed before formatting, so both 12,34,567 and 1,234,567 are read as 1234567.
How is 1.23 Cr calculated?
Divide by 1,00,00,000 and round to the chosen decimals: 1,23,45,678 ÷ 1 Cr = 1.23 Cr.
Does Excel support Indian format natively?
Use the custom format [>=10000000]##\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0 — or simply format here and paste as text.
Disclaimer: This tool is for general information and estimation only. Tax rates and rules change — verify with official sources or a professional before acting. Read full disclaimer.