American Date format in Sharepoint/365

Visitor

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 

 

David

0 Replies