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
Geez, but Excel online is a piece of garbage. Same issue with the dates too. I need dates in UK dd/mm/yyyy format ACROSS our organisation, not randomly changing at the whimsy of MS.
So all our users now have to type dates as dd.mm.yyyy so they are stored as text, not values. They are then unusable for reporting, calculating date parameters like invoices overdue or SUMIFS etc.
This is a serious issue Microsoft, that you NEED TO FIX NOW. And please, no obtuse sub-menus or byzantine pages worth of settings.
that says "all dates for all users to dd/mm/yyyy format"......... forever
Excel online currently is like trying to work with one hand tied behind your back with someone punching you in the face at the same time. I utterly hate it and having to support users using it.
It is unbelievably frustrating and screwed up that MS cannot sort these utterly basic things out.
I agree and support you from South Africa.
I see New Zealand has the same issue.
We need to get hold of someone at MS as MS does not read these feedback requests.
Tweet: @windows365 @office365
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.