To change Indian number grouping to US-style commas in Excel for Microsoft 365 on Windows, select the cells, press Ctrl+1, choose Number, and turn on Use 1000 Separator (,); then set decimal places and click OK. If Excel continues to show Indian grouping, adjust the separators or use a US-style custom number format as explained below.
What the change does
Indian grouping places commas differently once a number reaches one lakh: 1,00,000, then 10,00,000. US grouping separates digits in groups of three: 100,000 and 1,000,000. In Excel, the cells still contain the same numeric values after you change their number format; only their displayed appearance changes.
For example, a stored value of 1234567.89 can display as 12,34,567.89 with Indian grouping or 1,234,567.89 with US grouping. Calculations, sorting, and numeric comparisons continue to use 1234567.89. Formatting does not convert rupees to dollars, change the value, or translate text in the workbook.
Change the selected cells in Excel for Windows
For a normal range of numeric cells, use Excel’s built-in Number settings:
- Select the cells, column, or range you want to change. To format a whole column, click its column letter; avoid selecting the entire worksheet unless that is genuinely what you intend.
- Press Ctrl+1 to open the Format Cells dialog. You can also right-click the selection and choose Format Cells.
- On the Number tab, choose Number in the Category list.
- Set the number of decimal places, check Use 1000 Separator (,), and review the sample in the dialog.
- Click OK.
For instance, if a cell contains 1234567.89 and you set two decimal places, US-style grouping should display 1,234,567.89. If it contains 1234567 and you set zero decimal places, it should display 1,234,567. The comma is a display separator, not a character added to the underlying number.
The Number category is appropriate for measurements, counts, and general amounts that should keep their numeric value. If the data represents money, you can instead choose Currency or Accounting and select the desired currency symbol. The symbol is separate from the grouping pattern: a US-style comma format does not, by itself, convert an Indian rupee amount into US dollars.
Use a custom format for more control
A custom number format is useful when you want a particular display pattern, such as a fixed number of decimal places, without changing the values. In a US English Excel setup, a common format for whole numbers is #,##0, and a format with two decimal places is #,##0.00. To apply one, select the cells, press Ctrl+1, choose Custom in the Category list, enter the format in the Type box, and click OK.
The number sign and zero have different roles: # is an optional digit, while 0 requests a digit, including a zero where needed. Thus #,##0.00 displays two decimal places, including trailing zeros: 25 becomes 25.00 and 1234567.8 becomes 1,234,567.80. A format of #,##0.## allows up to two decimal places without requiring zeros at the end.
Excel’s interpretation and display of separator characters can depend on its regional separator settings. If entering a code appears to produce different punctuation, look at the sample preview and check the separator settings in the next section rather than assuming the stored value has changed. Excel may also show localized versions of separators in the dialog.
Check Excel’s decimal and thousands separators
Excel normally takes its decimal and thousands separators from Windows regional settings. There is also an Excel setting to use different separators. In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Under Editing options, find Use system separators.
If that box is checked, Excel uses the system’s configured separators. If you clear it, you can enter a decimal separator and a thousands separator directly in the two fields below it. To use the familiar US punctuation, set the decimal separator to a period and the thousands separator to a comma. Click OK, then revisit the cell format and inspect the sample.
This setting affects Excel’s interpretation and display of separators more broadly, not just one selected range. Consider the impact on other workbooks before changing it, especially if you work with files created under another locale or exchange data with colleagues. If the goal is only to change a few cells, first try formatting the selection and avoid changing global settings unless the display remains unsuitable.
Make sure the cells contain numbers, not text
Number formatting works only on numeric values. A value that looks like 12,34,567 may be text if it was imported from a CSV, copied from a website, or stored with punctuation that Excel did not recognize under the current regional settings. Applying the Number format to text will not rearrange its commas because Excel treats the characters as text rather than a quantity.
Look for clues: text is often left-aligned by default, may have a green warning triangle, and may not respond to adding decimal places. These clues are not conclusive because alignment can be changed manually. Select a suspect cell and check the formula bar; if the cell contains a text string, it needs to be converted to a number before number formatting can work.
For a small number of cells, you may be able to select them and choose the warning icon’s Convert to Number option. For larger imports, use Data > Text to Columns and check the data preview and locale-related options, or re-import the source with the correct regional settings. Always confirm the result on a sample: removing commas indiscriminately can corrupt text identifiers, account codes, or values that use a comma as a decimal mark.
Common problems and how to diagnose them
- The value still appears in Indian grouping: Check whether the selected cells are numeric, then inspect the Format Cells preview and Excel’s separator settings. A style or another number format may also be applied to the cells.
- Only some cells changed: The range selection may have skipped rows or cells. Select the full intended range and apply the format again. Merged cells and cells with different formats can make a selection look inconsistent.
- The comma changes to a period: Excel is using different regional separators. Verify the system separators and any custom Excel separators. A period in place of a comma does not necessarily mean the number is stored incorrectly.
- Leading zeros disappear: Excel is treating the entry as a number. Numeric formatting is designed for quantities, not codes. For postal codes, IDs, or account numbers where leading zeros matter, store them as text or use a suitable fixed-width format.
- A date or currency symbol changed too: Those are separate parts of a number format. Choose an appropriate Date, Currency, or Accounting category and inspect the sample before applying changes.
If the display looks wrong after changing formats, use Ctrl+Z immediately if appropriate, or reopen Format Cells and restore the previous format. Changing a number format is usually reversible, but converting imported text or replacing characters is a separate operation and deserves a backup first.
Apply the format consistently across a workbook
To format multiple non-adjacent ranges, hold Ctrl while selecting each range, then apply the number format once. You can also copy a correctly formatted cell and use Home > Paste > Paste Special > Formats to copy formatting without replacing the destination values. Check the result carefully if the destination includes dates, percentages, or text labels, since applying a number format to unrelated data can make it display unexpectedly.
For a reusable layout, format the relevant columns in a template workbook and save a separate copy for future use. Changing a style or format in one workbook does not automatically change every existing workbook. New workbooks can also inherit defaults from Excel’s template and regional configuration, so test the workflow with a new file if consistency across future workbooks matters.
Excel for Mac and Excel for the web
In Excel for Mac, select the cells and use Command+1 to open Format Cells, then choose a number format and set its decimal places and separator option where available. Windows uses Ctrl+1. To adjust Excel’s separators on Mac, look in Excel > Settings (called Preferences in some releases) and open Advanced; the exact labels can vary by version. If the setting is unavailable or the behavior differs, check macOS regional settings and use the Format Cells preview to confirm the display.
Excel for the web provides common choices through Home > Number Format. Its available controls can differ from the desktop app, particularly for regional settings and custom formats. If you need to set application-level separators or troubleshoot an imported text value, open the workbook in desktop Excel, make the change there, and verify it in the web version afterward.
Frequently Asked Questions
How do I change Indian commas to US commas in Excel?
Select the numeric cells, press Ctrl+1, choose Number, and enable the thousands separator. If the grouping remains Indian, check Excel’s system separators under File > Options > Advanced, or use a suitable custom number format.
Will changing the number format change the actual number?
No. Applying a number format changes how a numeric value is displayed, not its stored quantity. For example, 1234567 can display as 1,234,567 while remaining the same value for calculations.
Why does Excel not change the commas in my cell?
The cell may contain text rather than a numeric value, or Excel may still be using separators associated with another regional setting. Check whether it is numeric, then review the cell’s format and Excel’s separator options.
Can I change Indian formatting for just one column?
Yes. Select that column or the specific range and apply Number or a custom format. This changes the selected cells’ display without changing the separator settings for all Excel workbooks.
Does US number formatting convert rupees to dollars?
No. Grouping controls where digit separators appear. To display a currency symbol, choose a currency or accounting format and select the appropriate symbol; changing the symbol still does not perform a currency conversion.
Related
- Excel Column K Number: What It Means and How to Find It
- ICD-10 Z Codes List in Excel: Find, Import, and Check
- Excel Color Scales: How Conditional Formatting Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Present PowerPoint Without Showing NotesYes. PowerPoint normally keeps speaker notes off the audience’s slide show; to make sure they stay private, present…
- Excel Conditional Formatting: Can It Hide Columns?No. In Excel for Microsoft 365 on Windows, conditional formatting can change how cells look, but it cannot…
- How to Add Weekday Dates in ExcelTo add dates that skip Saturdays and Sundays in Excel, enter your first date in A2, then enter…
- Making a Template in Word: Steps, Styles, and SetupTo make a template in Microsoft Word for Microsoft 365 on Windows, create or open a document with…
- Bi-Monthly Budget Template in Google Sheets: Setup GuideA bi-monthly budget template in Google Sheets can track income, planned spending, and actual expenses for each pay…
- Google Sheets Duplicate File: How to Make a CopyTo duplicate a Google Sheets file in a web browser, open the spreadsheet and choose File > Make…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.