Fix Incorrect Date Formats in Excel Online for Business
Question details
The user needs Excel Online for Business to display dates in UK format instead of US format.

- Product
- Excel Online for Business
- Device & OS
- not provided
- Scenario
- A workbook is opened from OneDrive for Business while Windows and account settings use English (United Kingdom).
- Observed behavior
- Dates appear in US format, and the OneDrive for Business gear menu does not show a regional settings option.
Open the affected workbook from OneDrive for Business and identify a date cell that displays incorrectly. Confirm whether the underlying date is correct before changing its display format.
Check Excel and SharePoint regional settings
Use this approach when business workbooks display US dates despite UK Windows or personal account settings.
OneDrive for Business and its SharePoint site can use regional settings that differ from Windows or personal OneDrive. Available settings and permissions vary by organization.
In Excel for the web, open File > Options > Regional Format Settings if available. Select English (United Kingdom) or the appropriate UK regional format, then apply the change.
In OneDrive for Business or the SharePoint site hosting the workbook, select Settings and look for Site settings > Regional settings. If the option is available, check that the locale is English (United Kingdom).
If Regional settings is missing or cannot be changed, contact your Microsoft 365 administrator and ask them to check the OneDrive for Business or SharePoint site locale.
Reopen the workbook in Excel for the web and check the affected date cells. If the issue persists, use Help > Feedback in Excel to report the behavior.

Apply a UK-style date format to selected cells
Use this option when the stored dates are correct but you need selected cells to display day before month.
Work with spreadsheet date formats in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet and adjust date formats while moving between office suites. It does not change Microsoft 365 or SharePoint regional settings.

Frequently Asked Questions
Why does Excel Online show US dates when Windows is set to the UK?
Excel for the web or the SharePoint site behind OneDrive for Business may use regional settings that differ from Windows. Check File > Options > Regional Format Settings in Excel and the business site's Regional settings if available.
Where can I change the OneDrive for Business regional settings?
In OneDrive for Business, open Settings and look for Site settings > Regional settings. If the option is unavailable or you lack permission, ask your Microsoft 365 administrator to check the site locale.
Will changing a cell's format fix a date entered in the wrong order?
No. A format such as dd/mm/yyyy changes how a stored date appears, not the underlying date. Check the cell's value and correct it if Excel interpreted the day and month incorrectly.
Can I use my personal OneDrive UK settings for a business workbook?
Not necessarily. OneDrive for Business can use separate organizational or SharePoint site settings, so check the settings for the business location where the workbook is stored.




