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
2025-09-11 - Still not working for me. I have tried all the solutions listed. (YES I really did try them all) But still no solution.
It should be simple. Convert this format "2/13/2024" to this format "2024/02/13" As I want to be able to sort all the dates from my downloaded Bank data in the YYYY-MM-DD format so that they all sort correctly for the whole year. *I still don't understand how the banking industry has not changed their format to correct this obvious sorting issue. (rant over)
What do you have exactly, text ("2/13/2024") which looks like a date; or date (2/13/2024) which is actually integer number (45335 if to apply General format)?