May 29 2021 09:47 AM
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 had an influence. I submitted this post before, but I am submitting it again, because I noticed that it happens only on the Date formatting. I am attaching the file. First column is a date. I am an university professor and use this command a lot to change dates into numbers to grade students by their task delivery date. Can someone help?
May 29 2021 09:54 AM
@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.
May 29 2021 10:00 AM
It depends on you Windows settings. Try to enter "29/5" instead of "29-5"
May 29 2021 11:01 AM
May 29 2021 01:50 PM
It doesn't work for any file or only for this specific one?
Jun 04 2021 05:58 AM
Jun 04 2021 06:23 AM
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.
Jun 04 2021 09:33 AM
SolutionJun 04 2021 10:49 AM - edited Jun 04 2021 10:50 AM
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?
Jun 04 2021 11:23 AM
Jun 04 2021 09:33 AM
Solution