Formatting Issues

Fix Excel Showing German Date Format Despite UK Regional Settings

Maira Mehtab Sep 22, 2026 869 views

Question details

Excel displays dates and expects TEXT function tokens in a German format (TT/MM/JJJJ) instead of the expected UK format (DD/MM/YYYY), even though the computer's regional settings are configured for English UK.

Product: Microsoft Excel
Device & OS: Windows
Scenario: Formatting date cells and using the TEXT function with specific date codes.
Observed behavior: Excel displays dates as TT/MM/JJJJ. Using English date codes in the TEXT function returns a #VALUE! error, while German tokens function correctly.

Before you start

Save your open workbooks and close Microsoft Excel completely, as changes to the Windows regional settings will only take effect in Office applications upon restart.

Solution 1Recommended

Reset Windows Regional and System Locale Settings

Toggling and reapplying your Windows regional settings forces Excel to refresh its locale recognition, fixing the display mismatch.

Even if your Windows regional settings appear to be correctly set to English UK, Excel can sometimes lose synchronization with the system locale. Resetting these settings manually pushes a fresh update to all Microsoft Office applications.

Close Microsoft Excel

Ensure Excel and all other Office applications are fully closed before making system changes.

Open Region Settings

Open the Windows Control Panel, navigate to 'Clock and Region', and click on 'Region' to open the format dialog.

Temporarily Change Region

Under the 'Formats' tab, temporarily change the Format dropdown to a different English region, such as 'English (United States)', and click 'Apply'.

Reapply English UK Settings

Change the Format dropdown back to 'English (United Kingdom)' ensuring the Short date shows DD/MM/YYYY, and click 'Apply'.

Verify System Locale

Switch to the 'Administrative' tab, click 'Change system locale', ensure it is set to 'English (United Kingdom)', click 'OK', and restart your computer if prompted.

Perform All Steps: It is highly recommended to perform these toggling steps even if your settings already look completely correct, as the act of applying a temporary change forces the system refresh.

Solution 2

Check Workbook Language and Custom Number Formats

Verify that individual cells or the workbook itself haven't been forced into a German locale via custom formatting codes.

Free Microsoft Office alternative

Enjoy Flawless Date Formatting with WPS Office

Tired of troubleshooting stubborn Microsoft Excel regional bugs and locale mismatches? WPS Spreadsheet provides a lightweight, highly compatible alternative with reliable formatting tools. It seamlessly reads your system settings without the glitchy behavior, ensuring your dates always display exactly as intended.

1. Download WPS Office: Install the free WPS Office suite on your Windows computer.
2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing Excel workbook.
3. Format Cells Reliably: Select your date columns, right-click to choose 'Format Cells', and easily apply your preferred English (U.K.) date format.

Highly compatible with Microsoft Excel (.xlsx, .xls) and standard CSV formats.Reliable date and time formatting that strictly respects your chosen locale.Intuitive user interface that makes finding cell formatting options a breeze.Lightweight design that functions smoothly without deep system registry dependencies.

Frequently Asked Questions

Why does the Excel TEXT function return a #VALUE! error for English dates?

When Excel gets stuck in a German system locale mismatch, it expects German formatting tokens (such as "TT" for days and "JJJJ" for years). If you use English tokens like "DD/MM/YYYY" in the TEXT function, Excel cannot parse the format string, resulting in a #VALUE! error.

Could an Office language pack be causing this date format issue?

While it seems related to language, this specific issue is rarely caused by a language pack. It is almost always a synchronization glitch between Microsoft Excel and the Windows system regional settings, which can be fixed by toggling the system locale in the Windows Control Panel.

How can I force Excel to use the UK date format regardless of Windows settings?

You can lock a cell to the UK locale by using custom formatting. Open the Format Cells dialog, go to the Custom category, and enter the code [$-en-GB]dd/mm/yyyy. This forces the display to the UK format even if the document is opened on a computer with a different default region.

Document & File Issues