Fix UK Date Entry in Excel 365 When US Dates Are Accepted
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.
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.
Check the affected user's OneDrive regional settings
Use this check when date entry differs between users in Excel for the web.
Sign in to OneDrive for Business as an affected user, select the Settings gear, and open OneDrive 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.
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.
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.

Compare date entry and cell formatting in Excel
Use this test to distinguish a date-entry interpretation issue from a display-format issue.
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.

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.




