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.
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.
- Microsoft is asking me to choose one as best answer, but that would be unfair, as I solved the issue myself. I am truly grateful to everyone that has tried to solve, everyone have a great day and a wonderful weeekend.
Don't care about best answers, but it'll be useful for other people if you share how did you solve you issue. And you mark your own answer as best.