So you are another complainant of Excel not changing the date format? You must know that you are not the only victim of this issue. This issue is reported by plenty of Microsoft Excel users. Somehow we have managed to extract the solution to this problem. Fortunately, the solution is really effective. It can solve Excel not changing the date format problem conveniently.
Procedure to Change Excel Date Format:
Here are the steps through which you can deal with the Excel not changing Date Format problem. Hopefully, after this solution, you don’t need to go to the second one.
- Launch Microsoft Excel on your computer.
- On the Top menu of Excel click on the Data tab.
- From the appeared menu, Select Text to Column.
- Right next to the Delimited option, there is a box that you have to Tick for activation.
- Click Next Button twice to move ahead of Setup Pages.
- Select Date.
- Click the drop-down menu.
- Choose the MDY custom option.
- Now click on the Finish button to end the procedure.
- Move on Excel Sheet, Select any empty Cell of your Excel Document.
- Press Ctrl+1 key on your computer keyboard.
- Choose the Custom format option present at the list’s bottom.
- In the text box type the time you want to mention, Year/month/Day is the sequence.
How to change the Windows default date format:
You can also change the Windows Default Date Format to the desired one. Sometimes users get confused with dates format. Especially people feel difficulty in differentiating the Month and Day number. So this procedure lets users set the Windows Time Format according to their ease. So, in the future, they don’t get confused.
- Press Windows Plus R Key (Win+R) on your PC’s Keyboard.
- Windows Dialog box will appear, type Control International and press enter.
- Go to the Formats Tab, check the default Date formats available.
- Choose the desired option after dropping down the list.
- At the end of OK to apply the Settings Changes.
Remember changing the Windows Default Date format will affect all stock programs. The changes will be applied to most of the Windows Software rather than Excel only. So, we recommend the first procedure if you want to bring change Date Format in Excel only.