Forum Discussion
Solved
Excel stopped formatting dates
My Excel just stopped formatting dates. Even if I select the column and use the format cells command again it does not work. I recently changed windows language from portuguese to english, maybe this...
- It was a regional setting. I changed Windows language from Portuguese to English. Here in Brazil we use dates as dd/mm/yy, and in the USA it is mm/dd/yy. So, when in Portuguese we enter date as 4-5, date goes as May 4th. We were at the end of the month, so I was entering 25-5 (expecting May 25th), and as there is no 25th month, Excel just did not change that. When June began, it was easy to guess, as I entered 1-6 and it was formatted as January 6th. Thanks again.
It depends on you Windows settings. Try to enter "29/5" instead of "29-5"
- Thank you very much. Formatting is 29-mai-21, I entered 29/5 and remained the same, 29/5.
It doesn't work for any file or only for this specific one?
- Thank you very much. All files.