I have my laptop, running Windows 10, set to English United States region, my O365 site region is set to United States, all excel formatting is set to display dates in US format mm/dd/yyyy
, however all my online excel files will only allow entry in UK formats and switches them to US display format.
e.g. if want to enter 23rd April 2018, I must enter 23/4/18
in order for it to display 4/23/18
. Any dates entered as us 4/23/18
get rejected as invalid dates.
This is not a formatting issue as I can clearly see the cell formatting is set to US date format mm/dd/yy
.
Does anyone know how to truly set the region of an O365 excel document?