Forum Discussion
UK Date format
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 Ki...
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.
Yip, ONEDRIVE:
I've also set Sharepoint and MS Teams to UK.
EXCEL ONLINE 😞
EXCEL DESKTOP 🙂
To be sure - your file is on OneDrive or on Sharepoint?