Forum Discussion
Solved
Date Formatting Won't Change
I have an excel column that includes dates currently formatted as MM/DD/YYYY. I want it formatted as YYYY/MM/DD. When I go to format cells and change the date format, nothing changes. If I try to cha...
- Finally figured this out.
Change the date format of your computer from the taskbar.
Regardless of timezone and all, go to your task bar> click the time/date > region >then look for additional date, time & regional settings > change date, time and number formats> additional settings> then go to the date tab and you can manually set the format by using the MMM dd yyyy or whichever format you want it in. Restart your computer and it should work on excel.
Wew
Hi Steve,
I guess you have text in your column, not dates (which are actually numbers). To convert you may use from ribbon Data->Text to Columns selecting Date and applying MDY on the third stage of the wizard.
I did that. Didn't do anything.
Steve,
After applying Sergei's solution, select the dates, press Ctrl+1 and then select Custom category.
After that, copy the format YYYY/MM/DD to the Type box, and then hit OK.
- hello, I have a similar problem, I have a whole column of dates (presumably stored as text). I have tried many options(including this) to format as date but nothing is changing
- If anyone still has the same problem: Maybe when you were typing in the data, you were doing it wrong. Try inputing 2021/05/23 instead of 2021.05.23
