SharePoint Document Issues

Fix SharePoint Online List Dates Ignoring Regional Settings

Aamir Naveed AkramAamir Naveed Akram Nov 14, 2026 869 views

Question details

The user wants SharePoint Online list dates to display in DD.MM.YYYY format instead of US format.

Fix SharePoint Online List Dates Ignoring Regional Settings
Product
SharePoint Online
Device & OS
not provided
Scenario
A SharePoint list is used on a site configured with English (United Kingdom) regional settings.
Observed behavior
List dates continue to appear in US format across newly created lists and other sites despite the configured regional settings.
Before you start

Identify an affected list, date column, and example date, and check whether the column stores a date only or a date and time. English (United Kingdom) regional settings may use a different separator, so they do not by themselves guarantee the exact DD.MM.YYYY display.

Solution 1Recommended

Check SharePoint site, user, and browser settings

Use these checks to identify conflicting locale settings when list dates do not match the site's regional configuration.

1
Review the site locale

On the affected SharePoint site, open Settings > Site information > View all site settings > Regional settings. Confirm the locale and time zone, then save any changes.

2
Check your profile settings

Open your Microsoft 365 profile and look for language and regional settings. Check whether a personal locale is set differently from the site's locale; available controls may vary by organization.

3
Compare browser settings

Open your browser's language settings and check the preferred language order. Then reload the list and compare it in a private browsing window or another browser.

4
Test with another user

Ask another user to open the same list and compare the same date. If the display differs by user or browser, focus on their profile and browser settings.

Check SharePoint site, user, and browser settings
Locale changes may not resolve the issue: The reported behavior also occurred in new lists and on other sites. If the settings are consistent but the display remains incorrect, collect examples and contact your Microsoft 365 administrator or Microsoft Support.
Free Microsoft Office alternative

Format exported list dates in WPS Spreadsheets

WPS Office is a free, lightweight alternative for working with spreadsheet copies of list data. Its familiar interface and Microsoft Excel format compatibility make it easy to move existing files and format dates locally. It does not fix SharePoint Online settings.

Apply date formats to spreadsheet copies of list dataOpen and save Microsoft Excel XLSX filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why do my SharePoint list dates still look American after I change the site locale?

The display may be affected by user, browser, or column settings, and the reported issue persisted even on other sites. Compare the same list with another user and inspect the column's formatting before concluding that the site locale is the cause.

Does English (United Kingdom) guarantee dates use dots?

No. A UK locale does not necessarily produce the exact DD.MM.YYYY format. Check the displayed result and any column formatting separately.

Where can I check whether a SharePoint date column has custom formatting?

In the list, select the column header and choose Column settings > Format this column. Inspect any existing formatting before changing it.

Will formatting a date in Power Automate change the SharePoint list display?

No. An expression such as formatDateTime affects the flow output where it is used, not the list's display. Check the list column and regional settings separately.

Can WPS Office fix SharePoint Online regional settings?

No. WPS Spreadsheets can format dates in a spreadsheet copy of list data, but SharePoint Online settings must be investigated in Microsoft 365.