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
Hye..
This is not a bug oh ms excel.
You have to justify that where is your date and where is your month in the date..
For example data is 11/12/2020 (in this case excel can understand mm/dd/yyyy and also dd/mm/yyyy both of them you can aply on it) but of data is 24/12/2020 the excel (in this case you cant apply mm/dd/yyyy)
So that..
Firstly you have to justify your data to excel where is date and where is month in the column for that steps are :
1. Select the column or data do you want to change in any format..
2. Then click on data tab.
3. Click on Text to columns.
4. Step 1 of 3 is Delimited (defult selected option) then next.
5. In step 2 of 3 just tick on tab and treat consecutive delimiters as one. Click next.
6. Here on the date option you can tell that where is your date and month in the column.. MDY stands for MONTH DATE YEAR, DMY stands for DATE MONTH YEAR. Select the option as your data in column.
7. Click on finish..
Now you can format your date month year in excel as custom options as well as date options.
Please click on like button if useful : )
This is not a bug oh ms excel.
You have to justify that where is your date and where is your month in the date..
For example data is 11/12/2020 (in this case excel can understand mm/dd/yyyy and also dd/mm/yyyy both of them you can aply on it) but of data is 24/12/2020 the excel (in this case you cant apply mm/dd/yyyy)
So that..
Firstly you have to justify your data to excel where is date and where is month in the column for that steps are :
1. Select the column or data do you want to change in any format..
2. Then click on data tab.
3. Click on Text to columns.
4. Step 1 of 3 is Delimited (defult selected option) then next.
5. In step 2 of 3 just tick on tab and treat consecutive delimiters as one. Click next.
6. Here on the date option you can tell that where is your date and month in the column.. MDY stands for MONTH DATE YEAR, DMY stands for DATE MONTH YEAR. Select the option as your data in column.
7. Click on finish..
Now you can format your date month year in excel as custom options as well as date options.
Please click on like button if useful : )
