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
In some cases, it seems Excel does not change the format even if all settings and everything is ok. I had YYYY.MM.DD (2025.08.06) and wanted DD. MMM YYYY (26 aug 2025). If I activated a cell and tab'ed out, the format changed, but I had 1000s of lines and did not bother. Solution: Mark row, replace all point with point, and then format changed as it should. It seemed that Excel had to "reinterpet" all cells before changing format. There might be other ways, but this worked.