How to Format Indian Number Grouping and Currency in Excel
Question details
The user wants to format numbers in Excel using the Indian numbering system (lakhs and crores) and display the Indian Rupee symbol (₹).
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Presenting financial or numerical data tailored for an Indian audience requiring the standard lakh and crore comma grouping.
- Observed behavior
- By default, Excel uses the standard Western 3-digit comma grouping (e.g., 10,000,000) instead of the Indian grouping (1,00,00,000).
Ensure your Windows operating system is up to date and close all open Excel workbooks before changing your system's regional settings to apply the new formatting smoothly.
Adjust Windows Regional Digit Grouping Settings
The most reliable way to apply the Indian numbering system globally across Excel is by changing your Windows regional settings.
Excel inherently relies on the Windows operating system's regional settings to determine how numbers are displayed by default. By changing the system-wide digit grouping, Excel will automatically adopt the lakh and crore format without requiring complex cell-by-cell adjustments.
Click the Start menu, type 'Control Panel', and press Enter. Navigate to 'Clock and Region' and then click on 'Region'.
In the Region window, click on the 'Additional settings' button located at the bottom of the Formats tab.
Under the 'Numbers' tab, locate the 'Digit grouping' drop-down menu. Select the Indian grouping format (e.g., 12,34,56,789).
Click 'Apply' and then 'OK'. Restart Microsoft Excel for the new default comma style to take effect globally.
Apply Custom Formatting for Lakhs and Crores in Excel
Use Excel's custom format cells feature to display the Indian Rupee symbol and grouping for specific cells without changing system settings.
Format Indian Currency and Numbers Easily in WPS Spreadsheet
WPS Spreadsheet fully supports regional formatting and advanced custom number formats, allowing you to easily apply Indian lakh and crore grouping to your financial data with a user-friendly interface.
- 1. Open WPS Spreadsheet: Launch WPS Office, open your document in WPS Spreadsheet, and select the target cells containing your numbers.
- 2. Access Cell Formatting: Right-click the selected cells and choose 'Format Cells' from the context menu.
- 3. Select Currency Category: Navigate to the 'Number' tab and click on 'Currency' or 'Accounting'.
- 4. Choose the Rupee Symbol: Select the '₹' symbol from the symbol dropdown list to apply the Indian Rupee format.
- 5. Apply Custom Grouping: If you need specific lakh and crore grouping without changing system settings, select 'Custom' and input ₹#,##,##0 into the type field.
Frequently Asked Questions
Why does Excel revert to the 3-digit grouping even after applying custom formats?
This usually happens because Excel's built-in comma style defaults to your system's regional settings. If your Windows region is set to the US or UK, Excel will prioritize the standard 3-digit grouping. Changing the digit grouping in the Windows Control Panel resolves this globally.
Can I apply Indian number formatting without changing my whole PC's regional settings?
Yes, you can use the 'Format Cells' > 'Custom' option in Excel and manually input a custom formatting string like ₹#,##,##0 for specific cells. This applies the format only to those cells without affecting other Windows applications.
Does the lakh and crore formatting apply automatically to charts and pivot tables?
If you have changed your Windows regional digit grouping, charts and pivot tables will automatically adopt the Indian numbering system. If you are using custom formats instead, you will need to apply the format specifically within the Pivot Table's 'Value Field Settings'.
