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
Steve Gould Hi steve, i have the same problem too not until i tried to change my computer’s date format and language to “Europe English” try adding it to your language settings if you’re trying to format your date to “MMDDYY” or else if USA english which is the default “DDMMYY” or try typing the date first for example 23 November 2023. Then restart your computer then try again to format your date. Hope this helps solve your problem.