Allow for British DD/MM/YYYY format when using OneDrive/Excel Online
When creating documents on Excel offline, as a British user the standard date format is always set to DD/MM/YYYY. When this is then uploaded to OneDrive and people work on the document online it automatically displays the date as the american MM/DD/YYYY, which causes all sorts of issues, especially with formulas and especially if people are entering dates once the document is online.
The following page does not follow the locale settings: https://account.microsoft.com/profile/
Excel for the web will use the regional setting of the site where the file is being saved. If the file is in your OneDrive, go to your OneDrive > Site Settings > Regional Settings and change the Locale to whichever you need. If the excel file lives in a Sharepoint library, then change the Sharepoint site's settings accordingly.
Has this been implemented yet? Guys! There are people using this in their organization globally. Does anyone know of an implementation queue where this issue has been logged so we can track it? Or is it simply being ignored?
Brian A commented
1) Open your spreadsheet in the app
2) Create a custom format:- [$-en-GB]dddd, d mmmm yyyy
3) And apply that to all of your dates - and save.
The the next time you open the spreadsheet in the browser you'll have "a proper" date! ;)
Brian A commented
If it is or isn't a British format is by the by.
Most of the countries in the world used DD/MM/YYYY!
It's the 4th of July, or is that why you refuse to implement.
Has a fix/workaround for this been released.
We have a mixture of staff using both the desktop and online apps. It makes it difficult for staff to remember which format to use.
We should not need to find someone with Admin Access to change a Global O365 setting,
When it is something that we should be able to decide to define in each and every spreadsheet we create.
Hilarious this still isn't fixed. A significant majority of the planet (we're talking two thirds or more) use DD / MM / YYYY.
To keep forcing your own parochial format on the rest of the world is just madness.
I appreciate Microsoft is an American company but if you wish to sell products outside of the US market you simply must accept the rest of the world do things differently.
YES. we do have customers from Australia have the same issue. :(
Kindly help look into and address it in the next release. Thank you.
Ori Klein commented
This POS persists even in the older versions.
And from what I can see on google this has been plaguing Excel forever. Since as early as 2006 and up to very now in the cloud 365 variant.
I work with the Home&Business 2013 office suite, and all it takes is for me to set a new spreadsheet in the same workbook, copy rows from one sheet whereas the cells are already formatted to United Kingdom, and then paste special (keep column width) into the new sheet and the dates convert to Armenian.
My locale in the OS regional settings, by the by, is Israel/Hebrew with a gregorian calendar.
So the first person to suck on MS's pipe and come tell me it's a regional setting issue gets knackered in the upper deck. MS doesn't extract its settings from the OS (at least on windows 10 with that old version I have) at all, as it seems. So buzz off.
Used to work fine but in the last month more and more users have started to report this issue in both MS Teams and Excel online. Both the Language/Region settings in Chrome, MS Teams and Windows are all set to New Zealand...
Olav Rønnestad Birkeland commented
We have customers thats not very happy with this limitation, which I understand.
We thought Exchange Online Mailbox Regional Configuration might affect the date format in Exchange Online, because thats what MS support suggested.
Therefore I made a killer PowerShell script for going through 1000++ mailboxes without getting throttled, handling authentication timeout etc., and setting correct date format for all users. For no use. Nice. Thanks MS.
I have multiple users across multiple tenants that are being driven absolutely mad by this. We need a fix. Located in Australia and want to know that when we set a date as DD/MM/YYYY it will STAY that way regardless of how we are viewing the document.
This is starting to seriously impact on the quality of our data - which just isn't acceptable considering GDPR rules.
This should be an easy fix, Microsoft. We are a UK company with 90% UK clients and we have to avoid using Excel in a browser because numbers have to be typed in using US format. The only workaround is opening it in the desktop app.
Having the same problem, despite having entered UK preferences into OneDrive settings. Excel keeps reverting back to American date format, and ignores when I change the cell format individually. Most frustrating!!!
This is more a "everyone but a very small portion of the world" issue than a strictly British issue.
It would be great to be able to set the input format for dates consistently.
Another basic feature missing...
OMG this is an epic mistake!! I sincerely hope they will fix this VERY soon!
Tom Rendell commented
by the way, when I use excel online today I go to a date that appears to be written in UK format, but displays as American, when I go to number settings, choose specifically Date UK, it stays displayed in American --> now that surely is silly