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!
Have you tried the Text-to-Columns trick akaal_sahaye mentioned above? It worked for me. Kind of crazy to have to do this as a work-around, but now that I know it, it is fairly simple to implement.
- Yes I have tried this method first. The cells which have a formula work but its the cell that have date in them and not a number when I show the formula that do not work. So I am assuming that when the data is imported the dates are some how hard coded. You cannot change the format to anything at all.