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.
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.
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.
- Probably because May 24 Windows language was Portuguese, and in the 25th I changed it to English.
Great, thank for sharing. I only don't catch why 24-5 works (as in your file) and 25-5 doesn't work. Or in the sample file you changed dates manually?