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 have tried date to text and everything else mentioned here. But nothing changes the date. Everything with a formula changes as normal. But everything else won't change no matter what formatting is used. The file was exported as CVS and then saved as an excel file. Please help, this is doing my head!
It looks like you are trying to read US dates into a 'rest of world' setting. The dates like 11/12/2002 are treated at dates (the wrong date because it was meant as November but is read as December) whereas 1/26/2002 would be left as text because Excel fails to recognise the 26 month of the year. The best solution is to start again and use Power Query or similar to reimport the data.
The alternative is to play games and 'unscramble the eggs' with DATE, DAY and MONTH for the numbers and SEARH, MID, CONCATENATE and DATEVALUE for the text. Not nice!