₹ Formatter
Format any number with Indian commas (1,00,000 and 1,00,00,000), rupee symbol and optional decimals, ready to paste into documents. Free, no login.
In short
A rupee formatter converts plain numbers into Indian currency format with the ₹ symbol, two decimals and Indian comma grouping, so 1234567.89 becomes ₹12,34,567.89. VyaparKit's free ₹ formatter accepts a list of numbers, one per line, formats them all at once and copies the result for pasting into invoices, reports and presentations.
Formatted
₹12,34,567.89 ₹25,00,000.00 ₹99,999.00
Indian vs international grouping
12,34,567 (Indian) vs 1,234,567 (international). Excel defaults to international; use a custom format [>=10000000]##\,##\,##\,##0;[>=100000]##\,##\,##0;##,##0 to get Indian grouping.
About the ₹ formatter tool
Indian currency amounts are grouped in lakhs and crores: ₹12,34,567.89 rather than ₹1,234,567.89. Bank statements, GST returns, tenders and annual reports all follow this style, and a document that mixes the two looks careless. Spreadsheets, accounting exports from foreign software and copied web data usually arrive with international commas or no separators at all, so somebody has to fix them before a report goes out.
Doing that by hand across a column of fifty amounts is slow and error-prone; Excel's default en-US locale keeps reverting to millions, and Google Sheets needs a custom format string that most people do not remember. The ₹ formatter takes the whole list at once, one number per line, strips any stray commas or symbols, and returns each value as ₹ with Indian grouping and two decimals, ready to paste back.
Every VyaparKit document, ledger and report already uses this format, and the number to words tool produces the matching words when a report needs both.
How to format numbers in Indian rupee style
- 1
Paste your numbers
In 'Numbers (one per line)' paste a column of values from Excel, Google Sheets or a bank export. Existing commas and ₹ symbols are stripped automatically.
- 2
Check the formatted list
The result panel shows each number as ₹ with Indian commas and two decimals, for example ₹12,34,567.89 and ₹25,00,000.00, in the same order.
- 3
Copy the output
Press 'Copy' and paste the formatted list into your document, slide or email.
- 4
Fix Excel for the future
Apply the custom format from the note below the tool so your own sheets show Indian grouping without a converter.
How Indian grouping works, with examples
- Rule: place the first comma after three digits from the right, then a comma after every two digits. 1234567.89 becomes 12,34,567.89.
- Worked examples: 2500000 becomes ₹25,00,000.00; 99999 becomes ₹99,999.00; 100000 becomes ₹1,00,000.00; 10000000 becomes ₹1,00,00,000.00.
- Comparison: international style writes 1,234,567.89 (grouping in threes) while Indian style writes 12,34,567.89. The digits are identical; only the commas move.
- Two decimal places are standard for money: paise are always shown as two digits, so ₹5.5 is written ₹5.50.
- The rupee symbol ₹ (Unicode U+20B9) goes before the number with no space; 'Rs.' and 'INR' are older alternatives still seen on some documents.
- Negative amounts in reports are shown with a leading minus or in brackets: -₹1,200.00 or (₹1,200.00). Choose one style and keep it throughout a document.
- Excel custom format for Indian grouping: [>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00. Google Sheets: set File, Settings, Locale to India.
- Lakh and crore abbreviations (₹12.35 L, ₹1.23 Cr) are fine for dashboards and headlines but full figures should appear in invoices and statements.
Who uses the ₹ formatter
Accountants preparing reports
A CA firm in Pune pastes trial balance figures exported from a foreign accounting tool and gets a clean Indian-format column for the client's board pack.
Sales teams making proposals
A sales manager building a pricing slide converts a list of package prices to ₹ format with matching decimals.
Founders writing investor updates
A startup founder formats revenue and expense figures consistently before sending the monthly update.
Anyone cleaning bank export data
A shop owner formats amounts copied from a UPI app statement before pasting them into a WhatsApp summary for a partner.
₹ Formatter: frequently asked questions
- How do I write 1 lakh with commas?
- 1,00,000. The Indian system places the first comma after the last three digits and then after every two digits. Ten lakh is 10,00,000, one crore is 1,00,00,000 and ten crore is 10,00,00,000. In the international system one lakh would be written 100,000.
- How do I get Indian comma format in Excel?
- Select the cells, open Format Cells, choose Custom and enter [>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00. This shows lakh and crore grouping with two decimals. Alternatively change the Windows region to English (India) so the default Number format groups Indian style.
- Why does Google Sheets show 1,234,567 instead of 12,34,567?
- Because the spreadsheet locale is set to United States. Go to File, then Settings, and change Locale to India; existing and new number formats then use lakh and crore grouping. You can also use a custom number format the same way as in Excel.
- How do I type the rupee symbol ₹?
- On Windows press Ctrl + Alt + 4 with the English (India) keyboard, or hold Alt and type 8377 on the numeric keypad. On Mac use Option + 4 with the Indian keyboard layout or the emoji and symbols viewer. On Android and iPhone long-press the $ key on the keyboard and pick ₹.
- Should invoices show two decimal places?
- Yes. Money amounts on invoices, receipts and statements should show paise as two digits so columns align and totals can be checked, for example ₹1,180.00 rather than ₹1,180. Most GST invoices round the final total to the nearest rupee with a separate round-off line, but individual amounts still carry two decimals.