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.
LuisAraujo1948 Not sure how you enter the dates. When I select the cells at the bottom one-by-one and press Enter, they switch to the desired date format.