Enable UK users to use date format dd/mm/yyyy in one drive and excel online.
Can you please enable UK users to use date format DD/MM/YYYY as standard in Office 365 (especially Excel and Onedrive). I thought O365 will provide an excellent solution to our collaboration and file storage needs, but I have now had to delay/ put on hold deployment after discovering that dates automatically default to US format mm/dd/yyyy. I am aware that it is possible to display dates which are inputted in US format in the UK format, but these dates need to be inputted in US format. That does not come naturally to the team and and causes issues with formulas where a spreadsheet which has been prepared on a desktop version of excel is uploaded to online (onedrive/ excel). Surely, users in different regions should be able to work implement settings that work best for their regions.
When i contacted support i got the impression that because it has not been significantly discussed on this forum, it was not a major issue, however all you need to do is google the subject of this post and there you will see that this topic is discussed on various forums.
Here is an example on this forum;
But there is so much out there. Why should our organisation have to learn to use US date format just for one aspect of our work
In practice, the inconsistent application of regional settings means that it's impossible to know which date is being referenced to any given date displayed (especially on or before the 12th of every month) unless you know what format Microsoft is applying to it.
How could the end user know that? It's not like the format is published beside every use of a date!
UK user here.
Yes, I could not agree more with this. Regional date settings are not universally respected across Office 365. For example, if I do a general view of my Office 365 for Business OneDrive files, the date format is fine.
But if I do a search, the search results screens give the the date in a US format. I think Microsoft need to urgently sort this out; there is a big difference between dd/mm/yyyy and mm/dd/yyyy. Compare and contrast 11/10/2019 vs 10/11/2019. This could be a major issue for us.
We have the same issue here, users create in Excel 365 Desktop app which displays dates in UK date format then share via Teams / SharePoint, when opened in Excel Online (default for Teams) it uses US date format which confuses our users. Same goes for SharePoint Online, all previous version info is in PST and US date format, not useful in the UK.