American Date format in Sharepoint/365


Hello knowledgeable people


I have an Excel file which had data validation forcing user to enter a date in a particular column.  Everything worked fine until I shared the file on 365 sharepoint or whatever its called.  When users now try to enter a date for example 16/03/22 the validation tells them they must enter a date.  I noticed that if we enter the month first and enter 03/16/22 that the date is accepted and even shows correctly as 16/03/22!!!   


Very confusing for users ....... Can someone tell me how we can chage the date format from american to united kingdom please


Many thanks in advance 



0 Replies