Formatting Issues

How to Fix Excel Changing UK Dates to US Date Format

Olivia Miller Oct 12, 2026 868 views

Question details

The user needs to prevent the spreadsheet application from automatically interpreting UK-formatted dates (dd/mm/yyyy) as US-formatted dates (mm/dd/yyyy).

How to Fix Excel Changing UK Dates to US Date Format

Product: Excel
Device & OS: Windows
Scenario: Entering numerical dates such as 08/06/2004 into spreadsheet cells.
Observed behavior: Excel misinterprets the entered dates according to US regional settings, effectively swapping the day and month values even when the system is set to UK English.

Before you start

Verify that your Windows system regional settings are completely set to English (United Kingdom), as Excel often inherits its default date formats directly from the operating system's time and date configurations.

Solution 1Recommended

Manually Adjust Cell Formatting to UK Locale

Use the Format Cells menu to explicitly lock the date locale to the United Kingdom, preventing Excel from applying US defaults.

By default, Excel might apply a generic date format that adapts to unexpected regional behaviors. Explicitly setting the locale for your specific cells forces Excel to recognize and display the date in the exact dd/mm/yyyy format you intend.

Select the Target Cells

Click and drag to select the affected cell or range of cells where you plan to enter your dates.

Open Format Cells Menu

Right-click the selected area and choose 'Format Cells' from the context menu, or press Ctrl+1 on your keyboard.

Choose Date Category

Navigate to the 'Number' tab at the top of the dialog box, then select 'Date' from the Category list on the left.

Apply UK Locale

In the 'Locale (Location)' dropdown menu, select 'English (United Kingdom)'. Choose your desired dd/mm/yyyy format from the Type list and click OK.

Manually Adjust Cell Formatting to UK Locale

Tip: Applying this format to an entire column before entering data ensures all new dates adhere to the UK format automatically.

Solution 2

Enter Dates Using an Unambiguous Text Format

Type dates using the month abbreviation (e.g., 8 Jun 2004) to prevent Excel from confusing the day and month numerical values.

Smart Data Formatting Tool

Format Dates Seamlessly with WPS Spreadsheet

WPS Spreadsheet provides a highly intuitive interface for managing cell formatting and regional settings, ensuring your dates remain exactly in the UK format you type. It gives you full control over how your data is displayed without unwanted regional conversions.

1. Open Your File in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet or create a new one.
2. Select and Right-Click Cells: Highlight the columns or cells for your dates, right-click, and select 'Format Cells'.
3. Set the Date Locale: Under the Number tab, select Date, choose 'English (U.K.)' as your locale, and apply the dd/mm/yyyy format.

Easily apply and lock UK date formats (dd/mm/yyyy) without system conflictsFully compatible with Microsoft Excel (.xlsx) files and formattingLightweight, fast, and completely free to useFamiliar ribbon interface for seamless user migration

microsoft office alternative - wps office

Frequently Asked Questions

Why does my date format change back to US when I leave the cell?

This happens if the cell's underlying format is still set to a US locale or if your system's regional settings override the cell format. You must explicitly define the locale as 'English (United Kingdom)' in the Format Cells dialog.

Can I force a date to remain exactly as typed without formatting?

Yes. You can force Excel to treat your date as plain text by typing an apostrophe (') before the date (e.g., '08/06/2004). The apostrophe will hide itself, and the date will not be auto-formatted.

How do I change the default date format for all new spreadsheets?

Excel relies on your Windows Control Panel settings for its default formats. Go to Windows Settings > Time & Language > Region, and ensure the Regional format is set to English (United Kingdom) to apply it globally.

Document & File Issues