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
I am having the same issue converting Nov 01 2021 10:30 to 11/01/2021 10:30 it does nothing no matter what I try.
Has anyone found a solution to this? I am having your exact same issue. Tried windows settings, number formatting, custom formatting. I am at my wit's end. jwellesley2022
- Definitely, it is a bug in Excel. Open source spreadsheets (OpenOffice, LibreOffice) behave the way Excel should/did.
I wouldn't call it a bug since Excel is most likely behaving exactly intended. If the date is not provided in a format that conforms to your machine locale it will be read as text and no amount of number formatting will help. If you are importing the data, it should be possible to use PowerQuery to convert the date format or, within Excel, date to columns can be instructed to accept 'foreign' formats.
Have a look at SergeiBaklan 's replies in this thread.
