Date changing to american format when sharing 365excel file.

Copper Contributor

I have tried to make sure windows date format is set to London, also excel date formatted to non asterisk date but the date still requires user to enter date in American format. Display is showing as uk format but when clicking on a cell it shows not as 02/01/18 but 01/02/18. 

I don't know what to do next. 

 

Instruction Date

02/01/18
03/01/18
08/01/18
10/01/18
 
 
 
 
 
0 Replies