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.
@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.
@Jan Karel Pieterse
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.