'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Change Excel from Indian to Western Thousands Separators
Question details
The user needs to change the digit grouping format in Excel from the Indian system (lakhs and crores) to the Western system (millions and billions).
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Displaying large numbers and financial data in Excel using the Western thousands separator instead of the Indian format.
- Observed behavior
- Excel displays numbers as 10,00,000.00 based on Windows regional settings, and standard cell number formats alone cannot reliably override this global behavior.
Save and close any active Excel workbooks before proceeding. Modifying system-wide regional settings requires Excel to be restarted to properly register the new thousands separator.
Modify Windows Regional Digit Grouping Settings
Adjust your system's Control Panel region settings to enforce the Western digit grouping globally across Windows and Excel.
Because Excel inherits its default number formatting directly from your computer's operating system, changing the Windows regional settings is the most reliable way to permanently switch from the Indian numbering system to the Western format.
Press the Windows key + R on your keyboard simultaneously to open the Run command window.
Type 'control international' into the text box and press Enter to open the Region settings panel.
At the bottom of the Region window, click on the 'Additional settings...' button to customize your data formats.
Under the 'Numbers' tab, locate the 'Digit grouping' dropdown menu and select the Western format (123,456,789) instead of the Indian format.
Switch to the 'Currency' tab at the top of the window, apply the exact same digit grouping choice from the dropdown, and click OK to save your changes.
Reopen your Excel workbook. Your numbers will now automatically display using the Western thousands separator.
Apply Locale-Specific Custom Number Formatting
Force a specific cell or range to use the Western thousands separator by applying a US-English locale code in the custom format.
Easily Manage Custom Number Formats in WPS Office
Need to apply Western thousands separators to specific documents without altering your computer's global regional settings? WPS Spreadsheet offers robust custom formatting tools to help you display financial data exactly how you need it.
- 1. Open Your Data in WPS Spreadsheet: Launch WPS Office, open your spreadsheet, and highlight the cells containing the numbers you wish to format.
- 2. Access the Format Cells Menu: Right-click the highlighted area and select 'Format Cells', or press Ctrl+1 on your keyboard.
- 3. Apply a Custom Locale Format: Click on the 'Custom' category under the Number tab. Enter '[$-en-US]#,##0.00' to force the Western thousands separator.
- 4. Save Your Formatting: Click 'OK' to instantly update the digit grouping for the selected cells without affecting your entire Windows system.
Frequently Asked Questions
Why does Excel show Indian numbering (lakhs and crores) instead of millions?
Excel automatically inherits your computer's Windows Regional Settings for displaying numbers, dates, and times. If your system locale is set to India, Excel defaults to the Indian digit grouping system (e.g., 10,00,000) rather than the Western system.
Can I change the thousands separator for just one specific Excel file?
Yes. While changing Windows settings affects all files, you can override the format for a specific file by highlighting the cells, opening Format Cells (Ctrl + 1), and applying a custom number format with a locale code, such as '[$-en-US]#,##0.00'.
Does changing Windows regional settings affect other applications?
Yes, modifying the digit grouping in the Windows Control Panel will apply the Western thousands separator globally. This means other programs that utilize system region settings, including web browsers, accounting software, and other Office applications, will also update their number formatting.
