To change Excel from the common European format to the UK format in Microsoft 365 for Windows, go to File > Options > Advanced, clear Use system separators, then set Decimal separator to a full stop and Thousands separator to a comma. This changes how Excel displays and interprets numbers; it does not automatically convert numbers stored as text.
What European and UK number formats mean
The phrase European number format usually refers to a convention used in many continental European countries: a comma marks the decimal fraction and a full stop, space, or other character groups thousands. For example, the value one thousand two hundred thirty-four and fifty-six hundredths might appear as 1.234,56. In the UK, the usual equivalent is 1,234.56: a comma groups thousands and a full stop marks decimals.
Europe does not use one universal format, so a file described as European may use spaces or different grouping rules. The important first step is to check what the values in your source actually mean. In 1.234,56, the final two digits are decimal places; in a UK-style value, 1.234 may mean one point two three four rather than one thousand two hundred thirty-four. Misreading the marks can change a value by a factor of a thousand.
Excel can display the same stored numeric value with different separators. That is different from converting a text string such as 1.234,56 into a number Excel can calculate with. Choose the right fix based on whether the cells contain real numbers or text.
Change the separators in Excel for Windows
In Excel for Microsoft 365 on Windows, the separator option is an Excel setting rather than a number format for one selected range. Follow these steps:
- Open Excel and select File > Options.
- Select Advanced in the left-hand list.
- Under Editing options, clear Use system separators.
- Enter a full stop (.) for Decimal separator.
- Enter a comma (,) for Thousands separator.
- Select OK, then check a few representative cells.
With these settings, a numeric value of one thousand two hundred thirty-four and fifty-six hundredths should display as 1,234.56 when an appropriate number format is applied. The change is not restricted to the current selection or workbook: Excel uses these separators across its workbooks while the custom setting is active. If you want Excel to follow Windows again, return to the same screen and select Use system separators.
Use Windows regional settings instead
If you want Excel and other compatible Windows applications to follow UK conventions, leave Use system separators selected in Excel and change the Windows regional format. In Windows 11, open Settings > Time & language > Language & region and choose an appropriate UK regional format. The wording and available options can vary slightly by Windows version.
This choice is broader than changing two separators in Excel. Regional settings can influence how applications display dates, currency, and other locale-sensitive information. Before changing them, consider whether other software or people using the same computer rely on the existing region. If you only need UK separators in Excel, setting them directly in Excel is usually the more contained option.
On Excel for Mac, look in Excel > Settings (called Preferences in some releases) > Advanced for the system-separator option. The exact labels may differ by release. Excel for the web does not provide the same desktop Options dialog; its behavior can depend on the workbook’s regional settings and browser or account environment. For a repeatable desktop workflow, adjust the Windows or Mac Excel setting in the installed app.
Format numeric cells after changing separators
Separator settings control which marks Excel uses, but the cell’s number format still determines how many decimal places appear and whether thousands are grouped. Select the cells, press Ctrl+1 on Windows to open Format Cells, choose Number, set the decimal places, and enable the thousands separator if appropriate. You can also use the number-format controls on the Home tab.
For example, a numeric value of 1234.5 might display as 1,234.50 if the cell is formatted to show two decimal places, or as 1,235 if it is formatted with no decimal places. In the second case, Excel is rounding the displayed result; the stored value remains 1234.5. Formatting therefore changes appearance, not the underlying quantity. To show a fixed number of digits, choose the relevant decimal-place setting rather than replacing the value with typed punctuation.
Currency formats add another layer: the symbol and its position depend on the chosen currency format and locale. A UK separator setting does not automatically turn a euro amount into pounds or prove which currency a figure represents. Choose a currency format that matches the data, and keep the currency meaning clear in the column heading or source information.
Convert existing text values correctly
If cells contain text such as 1.234,56, changing Excel’s separators alone may leave the text unchanged. Text is not a numeric value, so it will not behave like a number in sums, averages, or calculations. A common clue is that a value stays left-aligned under the current cell format, although alignment is not a definitive test because users can change it manually.
For a small or one-time conversion, use Excel’s Text to Columns wizard and specify the source separators. Select the affected column, then choose Data > Text to Columns. Proceed through the wizard to its final step, select Advanced, and set the decimal and thousands separators to match the source text. For continental-style values, that will commonly mean a comma for decimals and a full stop for thousands. Finish the wizard and check the results before using them in calculations. Work on a copy first if the original text must be preserved.
For a recurring import or a larger dataset, Power Query is often safer. Import the file with Data > From Text/CSV, choose Transform Data, select the number column, and use Change Type > Using Locale (or the equivalent option from the column’s context menu). Choose a numeric data type and the locale that matches the source, such as a relevant continental locale. Then load the converted data. Setting the source locale tells Power Query how to interpret the punctuation instead of guessing from the UK display setting.
Always inspect examples with and without decimals, and check large values and negative values if they occur. A source string such as 2.500 is especially important to verify: depending on the source convention, it might mean two thousand five hundred or two and a half. If the source file mixes conventions, neither a single Text to Columns setting nor one locale will safely interpret every row; clean or separate the inconsistent data before conversion.
Why changing separators may not fix a workbook
There are several common reasons the result may look unchanged or wrong:
- The cells contain text. Changing separators affects numeric interpretation and display, not punctuation already stored in text. Convert the text using the source convention first.
- The format hides decimals or grouping. A cell set to show no decimal places will not display cents even when the value has them. Adjust the cell format as well as the separator setting.
- The values were parsed incorrectly on import. If Excel already treated a decimal mark as a grouping mark, the stored number may be wrong. Compare it with the source and reimport or convert from the original data where possible.
- Another setting is controlling Excel. If Use system separators is selected, Excel follows the system settings rather than custom separator entries. If you want a custom Excel-only choice, clear that box.
- The change affects more than one workbook. Custom separators are not a per-sheet switch. Review other open or future workbooks if they use a different convention.
Do not use Find and Replace to swap every comma and full stop in a mixed worksheet without checking the data. Those marks can also occur in dates, identifiers, descriptions, or text that should not be changed. Replacing punctuation in a text cell does not by itself guarantee that Excel will convert it into the intended numeric value.
Sharing files with people using other locales
When a workbook moves between computers, users can see the same numeric value with different decimal and thousands marks because their regional settings differ. That is normally a display difference, not a change to the stored number. By contrast, text values retain the characters entered, so a text string written as 1.234,56 may be confusing to someone expecting UK notation.
For a shared workbook, use genuine numeric values for quantities that need calculation and apply a suitable number format. Include units and currency clearly, and consider adding a short note about the source convention when importing external data. If recipients need a fixed text representation for a report or export, create that output deliberately and verify it in the destination system; do not assume that every recipient’s regional settings will produce identical display.
Frequently Asked Questions
How do I change a comma decimal to a full stop in Excel?
In Windows Excel, go to File > Options > Advanced, clear Use system separators, and enter a full stop as the decimal separator. This changes Excel’s separator behavior; text already containing commas may need conversion separately.
Will changing Excel separators change my actual values?
For cells that are already numeric, changing separators generally changes how the value is entered or displayed, not the stored quantity. Text is different: its punctuation remains literal until you convert it. Check any data that may have been parsed incorrectly during import.
Can I change the number format in just one worksheet?
You can format cells in one worksheet independently, including their decimal places and whether they show grouping. However, the decimal and thousands separator setting described above is an Excel-level setting, not a setting limited to one worksheet or workbook.
Why does Excel still show 1.234,56 after I changed the option?
First check that Use system separators is cleared and that you selected OK. Then check whether the cell contains text or has a format that affects its appearance. If it is text, use Text to Columns or Power Query with the source locale.
How can I tell if a number is text?
Try a harmless calculation on a copy or inspect the cell’s formula bar and alignment, but do not rely on alignment alone. A numeric cell responds to number formatting and arithmetic; text that looks like a number may not. For imported data, use Power Query’s type information or convert a sample and verify the result against the source.
Related
- Excel 3-Color Scale: How It Works and When to Use It
- Excel Conditional Formatting Based on Color: How It Works
- Conditional Formatting in Excel: Compare Dates
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Python pandas Excel Merge: Join Workbooks and SheetsTo merge Excel data with Python, read each worksheet into a pandas DataFrame with pd.read_excel(), then use pd.merge()…
- Out of Office in Outlook: Set Your Status and RepliesTo set out of office in Outlook, turn on Automatic Replies, enter your message, and—if you know your…
- Data Validation: Definition, Rules, and ExamplesData validation is the process of checking whether data meets defined requirements before it is accepted, stored, or…
- Save an Excel Workbook as a Copy Without Replacing ItTo save a separate copy of an Excel workbook in Microsoft 365 for Windows, open the workbook and…
- Find and Replace in Microsoft Word: Commands and ShortcutsIn Microsoft Word for Windows, press Ctrl+H to open Find and Replace; enter the text to search for,…
- How to Pull Up Archived Emails in Microsoft OutlookTo pull up archived emails in Outlook, open the Archive folder in your mailbox, or search your mailbox…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.