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
