Forum Discussion
Matching date input to the formatted date display
Hey there, I’m having an issue with date formatting. In my workplace, date entry is always done as dd/mm/yy. Therefore, I want excel to show the same thing. I formatted the cells to display “dd-mm-...
This is based on your computer's regional language settings. That's what Excel defaults to when interpreting dates. That's where you need to change things.