OneDrive File Issues

Change OneDrive for Business Dates from US to UK Format

Nimra MalikNimra Malik Nov 20, 2026 869 views

Question details

Change the OneDrive for Business site locale so dates use UK rather than US formatting.

Change OneDrive for Business Dates from US to UK Format
Product
OneDrive for Business in Microsoft 365
Device & OS
not provided
Scenario
A user wants dates on their OneDrive for Business site to follow United Kingdom regional settings.
Observed behavior
Dates appear in US format because the site uses its regional locale settings.
Before you start

Sign in to OneDrive for Business with the account whose dates you want to change. If you cannot access site settings, you may need help from your Microsoft 365 administrator.

Solution 1Recommended

Change the OneDrive site locale to United Kingdom

Use the site's regional settings to change how OneDrive displays dates.

1
Open site settings

In OneDrive for Business, select the Settings gear, then choose Site settings.

2
Open regional settings

On the Site Settings page, select Regional settings.

3
Set the UK locale

Under Locale, select English (United Kingdom) or United Kingdom, then select OK or Save to apply the change.

Change the OneDrive site locale to United Kingdom
Menu availability: Settings can vary by organization and interface. If Site settings only refreshes the page or is unavailable, try the direct regional settings link below.
Free Microsoft Office alternative

Work with Office files in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with Office files. Its format compatibility helps make migration easier, though it does not change OneDrive's site regional settings.

Work with dates in spreadsheets using cell formatting toolsOpen and edit Microsoft Office formats such as XLSX, DOCX, and PPTXUse a familiar interface that makes switching easierGet a lightweight office suite with free features
microsoft office alternative - wps office

Frequently Asked Questions

Why are my OneDrive dates showing in US format?

OneDrive for Business uses its site's regional settings for date formatting. Open Settings > Site settings > Regional settings and check the Locale selection.

What can I do if Site settings only refreshes the page?

Append /_layouts/15/regionalsetng.aspx to your personal OneDrive SharePoint site URL and open it in your browser. If it still does not open, try another browser or ask your Microsoft 365 administrator for help.

Will changing the OneDrive locale change dates inside every spreadsheet?

Not necessarily. The site locale controls site-level date formatting; dates inside an Excel workbook can have their own cell formats. In Excel, select the cells and use Home > Number Format to change their display.

What is the UK date format?

The UK commonly displays dates as day/month/year, such as 31/12/2026. Select the United Kingdom locale in Regional settings to use UK regional conventions on the site.