Apr 11 2019 03:08 AM - edited Apr 11 2019 09:06 AM
I am new here and will appreciate some help with Excel Online
I wish to format my dates in a single column as dd/mm/yy for UK format. My Control Panel options are set to locale of English (United Kingdom).
Ideally I would like to be able to type 11/04 into a cell which should appear as 11/04/19 but it instead appears as 04/11/19 despite the format being set correctly. This is obviously frustrating.
Looking at the attached screenshot, the first few dates in the column are set to text format because I was experimenting. The next few are formatted as short date UK.
Thank you!
Apr 11 2019 09:28 AM
Apr 11 2019 09:35 AM
@Michael188 , yes, as Jan Karel answered you shall to define UK locale for your OneDrive, not for PC. Settings are different depends on you use OneDrive Personal or Business one.
Apr 12 2019 01:19 AM
Thank you. I have asked my internal IT support to update that option within OneDrive (which is currently not a valid locale) and I will respond back later when it has been done.
Nov 18 2019 07:18 AM
Hi Sergei
In my hunt for an answer re an almost identical issue, I have seen your name pop up several times providing a successful solution, but i still can't get this to work.
My issue:
So far:
Do you have any other suggestions?
Cheers
Helen
Nov 18 2019 08:05 AM
Hi @Jan Karel Pieterse
I'm using Chrome and its set to:
Language: english (UK)
Region: United Kingdom
Nov 18 2019 08:34 AM
And the same is for OneDrive setting?
Time zone is not critical from this point of view.
Here is what I have with above OneDrive for Business settings
and two digits date 2/1
IMHO, itself browser settings and client Windows settings shall not affect.
Nov 19 2019 08:28 AM
Yip, ONEDRIVE:
I've also set Sharepoint and MS Teams to UK.
EXCEL ONLINE :(
EXCEL DESKTOP :)
Nov 19 2019 12:44 PM
To be sure - your file is on OneDrive or on Sharepoint?