Cell Formating

Copper Contributor

I have searched and searched without able to find a good solution. When I enter dates into a cell either in a general format or set a specific date format xx-xx-xx it changes it when I get to September dates. When date 2-22-20 is entered it goes in just fine, I then enter 9-2-20 and it converts it to show as 2-9-20. I have selected may different date formats and it still wants to convert the way it is showing. I found a way around it but noticed I forgot a date and went to sort and it is all wrong now. Any help would be appreciated in this.

1 Reply

@Jeff_Schnabel 

What is your system date format? While you can display dates any way you want, you MUST enter them according to your system date format.