Formatting Issues

Fix UK Date Entry in Excel 365 When US Dates Are Accepted

John WilsonJohn Wilson Nov 14, 2026 869 views

Question details

Some users need Excel 365 to interpret and display dates using UK conventions instead of US conventions.

Product
Microsoft Excel 365 and OneDrive for Business
Device & OS
not provided
Scenario
Users in a UK charity enter dates in a shared workbook in Excel for the web or desktop Excel.
Observed behavior
Some users encounter US date conventions despite UK settings in Windows, Microsoft 365, and the workbook. The workbook works as expected for its owner in Excel for the web.
Before you start

Identify an affected user and whether the issue occurs in Excel for the web, desktop Excel, or both. Use a new workbook or an editable test cell to avoid changing protected or shared data.

Solution 1Recommended

Check the affected user's OneDrive regional settings

Use this check when date entry differs between users in Excel for the web.

1
Open OneDrive settings

Sign in to OneDrive for Business as an affected user, select the Settings gear, and open OneDrive settings.

2
Review regional settings

Select More settings, then Regional settings. Set the locale or country and region to United Kingdom and the language to English (United Kingdom), where those options are available, then save the changes.

3
Compare user settings

Repeat the settings check for a user whose dates work correctly and compare the regional options. If an option is unavailable, ask the Microsoft 365 administrator to review the applicable settings.

4
Test both workbooks

Open a new workbook in Excel for the web and enter 13/02/2025 in an editable cell. Then test the affected workbook in a permitted cell and check whether Excel recognizes the entry as February 13, 2025.

Check the affected user's OneDrive regional settings
Settings may vary: OneDrive settings menus can vary by organization. Regional settings may affect the web experience but do not necessarily control date entry in desktop Excel.
Free Microsoft Office alternative

Work with Date Formats in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks and format date cells while moving your work between office suites.

Format spreadsheet date cells for your preferred display.Open and edit compatible Microsoft Excel XLSX and XLS files.Use a familiar interface for a smoother transition from Microsoft Office.Work with a free, lightweight office suite.
QA img-9

Frequently Asked Questions

Where are the OneDrive for Business regional settings?

In OneDrive for Business, select the Settings gear, open OneDrive settings, and look under More settings for Regional settings. Menu names and availability can vary by organization.

Why does the same workbook handle dates differently for different users?

Users may have different regional settings or work in different Excel environments. Compare their OneDrive regional settings and test the same entry in Excel for the web and desktop Excel.

Will changing a cell to a UK date format fix date entry?

Not necessarily. Select the cell and open Format Cells to change how a recognized date is displayed. Date entry can depend on regional settings, so test the interpretation separately.

How can I test without using an ambiguous date?

Enter 13/02/2025 in a new workbook or an editable test cell. Because 13 cannot be a month, the result helps show whether the entry is recognized as a day-first date.

Does changing OneDrive regional settings also fix desktop Excel?

Not necessarily. Test desktop Excel separately and review the affected user's Windows regional settings if the issue occurs there too.