Change OneDrive for Business Dates from US to UK Format
Question details
Change the OneDrive for Business site locale so dates use UK rather than US formatting.

- 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.
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.
Change the OneDrive site locale to United Kingdom
Use the site's regional settings to change how OneDrive displays dates.
In OneDrive for Business, select the Settings gear, then choose Site settings.
On the Site Settings page, select Regional settings.
Under Locale, select English (United Kingdom) or United Kingdom, then select OK or Save to apply the change.

Open OneDrive regional settings directly
Use the direct SharePoint settings page if the OneDrive settings menu does not open it.
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.

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.




