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-yy.” The problem is, it seems to interpret the input as yy/mm/dd regardless of the format I use.
The input must be dd/mm/yy, and the output must be the same.