Formatting Issues

Fix Incorrect Date Formats in Excel Online for Business

John WilsonJohn Wilson Nov 14, 2026 869 views

Question details

The user needs Excel Online for Business to display dates in UK format instead of US format.

Fix Incorrect Date Formats in Excel Online for Business
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.
Before you start

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.

Solution 1Recommended

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.

1
Check the workbook's regional format

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.

2
Check the business site locale

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).

3
Ask an administrator

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.

4
Reopen and verify

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.

Check Excel and SharePoint regional settings
Personal settings may not apply: A UK language or region setting in personal OneDrive does not necessarily control a workbook stored in OneDrive for Business.
Free Microsoft Office alternative

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.

Format spreadsheet date cells in a familiar interfaceCompatible with Microsoft Excel XLS and XLSX filesFree and lightweight for everyday office workA familiar layout makes migration from Microsoft Office easier
microsoft office alternative - wps office

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.