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 using excel365 online from a sharepoint file. I have my computer set as default to UK date format and everytime I open the file I reset the dateformat to UK using file options, control 1, and then setting the file format to UK. But to no avail, the file instantly defaults to US and the cells do not change globally. Worse still some of cells are in US format and some in UK.
I just want to use UK format and have followed all the advice given in this thread and others.
I just want to use UK format and have followed all the advice given in this thread and others.
Excel for web has no idea about regional settings on your computer, you need to change them on web (SharePoint/OneDrive site) as well. That's in File->Options within Excel for web
I have just tried your solution again since there were a few earlier dates that I had not changed. this is the result. As you can see the change is not global. Some cells change others don't.
On your sample it's hard to understand where are dates and where months.
- Hi Sergei
That's my problem, the top line is mm/dd/yyyy and the second line is dd/mm/yyyy.
I have now gone through all the dates and set them to UK by hand. I hope that this holds when I next open the file.
- Thanks Sergei
I do this every time as I explained. However, excel defaults to US every time I open it. I then reset it as you describe, but the change does not affect all dates globally.
I then try and use control 1 and change the formatting there since the options doesn't work. Unfortunately that hassn't worked either.
I have now changed all the dates by hand and hope that this will hold. If it doesn't, I think that there's a problem with the software.I tried on my site, it works
and
and
Do you really have dates or these are texts which looks like dates?