Fix SharePoint Online List Dates Ignoring Regional Settings
Question details
The user wants SharePoint Online list dates to display in DD.MM.YYYY format instead of US format.

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

Inspect the list date column and its formatting
Check whether a column's settings or custom formatting affect how dates appear in the list.
Format dates separately in Power Automate
Use this when dates appear incorrectly in a flow's output, such as an email or generated text.
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.

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.




