To change Excel from European-style numbers such as 1.234,56 to US-style numbers such as 1,234.56 in Microsoft 365 for Windows, go to File > Options > Advanced, clear Use system separators, and enter a period for Decimal separator and a comma for Thousands separator. This changes how Excel displays and interprets separators; if the values are stored as text, convert them separately.
What European and US number formats mean
The difference is the symbols used to mark the decimal fraction and group thousands. In common US formatting, a comma groups thousands and a period marks decimals: 1,234.56. In many European regional formats, a period groups thousands and a comma marks decimals: 1.234,56. Conventions vary by country, so “European format” does not describe every European workbook.
Excel distinguishes between a value and the way that value is shown. A real numeric value can be stored as the number 1234.56 and displayed with different separators according to Excel’s settings and the cell’s number format. But a cell containing the characters 1.234,56 as text is not automatically the same thing as the numeric value 1234.56. That distinction explains why changing separators may fix the display in one workbook but leave another workbook unchanged.
Before changing a large file, check a few representative cells. Select a cell and look at the formula bar: a number may appear there in a form different from its formatted display. Also check whether formulas can use the values in arithmetic. If a value is text, calculations may ignore it or return an error, even if it looks like a number on the sheet.
Change Excel’s separators on Windows
These steps apply to the desktop version of Excel for Microsoft 365 on Windows. The setting is in Excel, not in the workbook’s number-format menu.
- Open Excel and choose File > Options.
- Select Advanced, then find the Editing options section.
- Clear Use system separators.
- Set Decimal separator to a period (
.) and Thousands separator to a comma (,). - Select OK, then inspect several values and formulas in the workbook.
For numeric cells, Excel should now show a value such as 1234.56 as 1,234.56 when the cell’s number format includes two decimal places and a thousands separator. The setting applies to Excel’s separator behavior, not just the currently selected cells. To restore the Windows-based behavior, return to the same dialog and select Use system separators.
Excel’s decimal and thousands separators are not the same setting as a cell’s number format. If the separators are correct but a cell still has no grouping, select the cells and choose Home > Number, then choose a suitable number format. For more control, press Ctrl+1 to open Format Cells, select Number, and set the decimal places and thousands separator option.
Choose between Excel settings and Windows region settings
Use Excel’s separator options when you want Excel to use US-style separators without changing the display conventions in other Windows apps. If you want Windows and applications that follow its regional preferences to use US conventions too, change the Windows regional format instead. In Windows 11, open Settings > Time & language > Language & region and choose an appropriate regional format, such as English (United States). The precise labels can vary slightly by Windows version.
When Use system separators is selected in Excel, Excel follows the system separators. When it is cleared, the values entered in Excel’s two separator boxes control Excel instead. This is useful for people who work with files from different regions, but it can also cause confusion if the separators used while entering data differ from the ones a user expects. Decide whether you need a change for Excel alone or for the computer more broadly before changing settings.
Regional settings can also affect conventions such as dates, currency, and the way data is interpreted during import. They do not translate labels, convert currencies, or guarantee that every existing text value becomes a number. For a workbook shared with colleagues, document the intended convention and consider testing the file on another computer before sending it.
Format numeric cells without converting their values
If the cells already contain numbers, you usually do not need to replace the data. Adjust Excel’s separators and, if needed, the cells’ number format. For example, a numeric value of 1234.5 can be displayed with two decimal places as 1,234.50. That is a display choice; it does not change the underlying value to a different amount.
To apply a format to a range, select the cells, press Ctrl+1, choose Number, and specify decimal places and whether to use the thousands separator. You can also choose formats from Home > Number. A number format such as Currency may add a currency symbol, but it does not convert one currency into another. Avoid applying a currency format simply to change punctuation.
Formatting is often the right fix when values are already numeric and the problem is only how they look. It is not the right fix when Excel treats the entries as text. A cell format can change the appearance of a number, but it cannot reliably parse a text string whose punctuation follows a different regional convention. If sorting or summing produces unexpected results, verify the data type before spending time adjusting the display.
Convert European-style numbers stored as text
If imported entries such as 1.234,56 are text, convert them using the punctuation that appears in the source. One built-in option is Text to Columns:
- Select the text values, then choose Data > Text to Columns.
- In the wizard, proceed to the final step. If the source does not contain the default tab delimiter, leave it unselected or ensure no delimiter will split the values.
- Choose Advanced and set the decimal separator to a comma and the thousands separator to a period for this European-style input.
- Confirm the choices and select Finish. Check that the results are numeric, then apply the desired US display format.
For a small number of cells, Excel’s NUMBERVALUE function can parse text while explicitly naming the source separators. With the text string 1.234,56 in A2, use =NUMBERVALUE(A2,",","."). The formula returns the numeric value 1234.56: the second argument identifies the source decimal separator, and the third identifies the source grouping separator. Format the result separately if you want it displayed as 1,234.56. This approach is useful when you want to retain the original column and create converted values beside it.
Do not remove every period or comma with Find and Replace unless you have verified the data pattern. Replacing punctuation blindly can turn decimal fractions into different numbers or damage entries that use another convention. Keep a copy of the original column until you have confirmed that the converted values are correct.
Use Power Query for recurring imports
For repeated files, Power Query can make the source locale explicit during import instead of relying on the computer’s default interpretation. In Excel for Windows, select the data in the Power Query Editor, right-click the relevant column, and choose Change Type > Using Locale. Select a numeric data type and the locale that matches the source text, such as a locale that uses a comma for decimals and a period for grouping. Then load the converted data into Excel.
This is especially useful when a monthly CSV or exported report arrives in the same European-style format each time. A query records the transformation steps, so you can refresh it with a new source file rather than repeating manual conversion. Check the preview and a few known values before loading: a wrong locale can produce errors or plausible-looking but incorrect numbers.
Power Query is not necessary for a one-off correction of a few cells. For a small range, Text to Columns or NUMBERVALUE may be faster. For a regular import process, a saved query is easier to repeat and audit. In every case, keep the source file or original column available until the conversion has been checked.
CSV files and common problems
A CSV file contains text separated by a delimiter; it does not preserve Excel’s full workbook formatting or its separator preferences. Depending on the source region and software, a CSV may use commas, semicolons, or another delimiter between fields. A file with comma-decimal numbers may use semicolons between columns so that the commas inside numbers are not mistaken for field breaks. This is one reason opening a CSV by double-clicking it can split or misread data.
When importing, use Excel’s data import tools and inspect the preview and type settings rather than assuming the file uses US conventions. In Microsoft 365 for Windows, the Data > From Text/CSV route lets you review a CSV before loading it; available options and labels may differ slightly with updates. If the preview interprets the source incorrectly, adjust the delimiter or regional interpretation before completing the import. Changing Excel’s display separators after a bad import will not repair columns that were already split incorrectly.
- Numbers do not change: Check whether they are text, and check that the cells are formatted as numbers rather than Text.
- Dates changed too: Review the import locale and regional settings; dates such as 03/04/2025 are ambiguous across conventions.
- Formulas behave differently: Excel may use locale-dependent formula conventions, including argument separators. Do not replace commas in formulas without checking their structure.
- Only some cells look wrong: Those cells may have a different number format, contain text, or include hidden spaces or other characters.
Before converting a complete dataset, test a few examples that include whole numbers, decimals, negative values, and any currency or date fields. Compare the results with the source document. A formatted result can look reasonable even when Excel has parsed the original characters incorrectly.
Excel for Mac and Excel for the web
In Excel for Mac, separator controls are generally found in Excel’s preferences or settings under Advanced, where you can turn off Use system separators and set the decimal and thousands separators. The menu may be labeled Excel > Preferences or Excel > Settings, depending on the Mac version. If the option is not where expected, use Excel’s Help search for “system separators.” The Windows path and keyboard shortcut are not a reliable guide to Mac menus; Command+1 opens Format Cells on Mac in versions that support that shortcut.
Excel for the web uses regional settings differently from the Windows desktop app. To adjust the workbook’s regional format in the web app, look under File > Options > Regional Settings, choose the relevant locale, and apply the change. This can affect number and date conventions for that workbook. If you need the desktop separator controls, an import workflow such as Power Query, or a conversion that is not available in your web experience, open the file in desktop Excel.
Frequently Asked Questions
Will changing the separators change the actual numbers?
No, not when the cells already contain numeric values. It changes how Excel interprets or displays separator characters, while cell formatting determines details such as decimal places. Text values may need a separate conversion step.
Why does 1.234,56 still appear the same after I change the setting?
It may be text rather than a number, or it may have been imported as text. Confirm the cell’s data type, then use Text to Columns, Power Query with the correct locale, or NUMBERVALUE to convert it.
Can I change the number format for just one workbook?
You can apply number formats to selected cells, and Excel for the web offers workbook regional settings. In desktop Excel for Windows, the system-separator checkbox is an Excel application setting rather than a per-cell format. Use number formatting for appearance, and take care when sharing a workbook with users whose locale differs.
Why does Excel use semicolons in some formulas?
Formula argument separators can depend on regional settings. This is separate from the thousands separator shown in a number. If a formula does not work after moving a workbook between locales, check the formula syntax in that Excel environment rather than changing punctuation in the data indiscriminately.
Does saving as CSV keep the US number format?
CSV does not preserve Excel’s workbook formatting in the way an Excel workbook does. The exported text and delimiter conventions can depend on Excel and regional settings. Reopen or import the CSV using the intended locale and verify the output before using it elsewhere.
Related
- Close Group Excel Shortcut: Close Workbooks and Rows
- Close Excel Shortcut: Windows and Mac Keys
- Checklist Template Excel: Set Up, Track, and Reuse Tasks
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Insert a Personal Signature in Word 365To insert a personal signature in Word 365, scan or photograph your handwritten signature, then choose Insert >…
- Compare Similarity Between Two Excel SheetsTo compare two Excel sheets, first decide whether the same cells should match or whether records may appear…
- Export Phone Contacts to Outlook on iPhone and AndroidTo export phone contacts to Outlook, save them from your iPhone or Android phone as a contact file,…
- Excel Protect Sheet: Can Users Clear Filters?Yes. In Excel for Microsoft 365 on Windows, you can protect a worksheet and still let users clear…
- How to Link a Word to a Website in Microsoft ExcelTo make a word in Excel open a webpage, put that word in a cell, select the cell,…
- Insert a Blank Row in Excel After Every Row of DataTo insert a blank row after every data row in Excel, add a temporary helper column, number your…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.