Now the question arises why Excel date format is not changing?

But nothing happened date format not changing in Excel. If in case you don’t want to show the time and for this, you have set the format of the column as Short Date. In the shown figure, you can see there is an imported dates column in which both data and time are showing. All your problem of Excel not recognizing date format is now been fixed in just a few seconds. Very soon, your Excel will read out all the imported MDY dates and after then converts it to the DMY format. Now in the ‘Column data format’ sections hit the date dropdown and choose the MDY or whatever date format you want to apply.Then immediately go through the data section and make a double click on these for removing all of these. If there are vertical lines with arrows present which are called column break lines.In the opened dialog box choose the option of ‘Fixed width’ and then hit the Next button.Now from the Excel ribbon, tap to the Data menu and choose the ‘Text to columns’ option.If you want then you select the complete column. Firstly you need to highlight the cells having the dates.Here are the fixes that you need to perform. Here are fixes that you need to apply for fixing up this problem of Excel not recognizing date format. Resolving date not changing in Excel issue is not that tough task to do but for that, you need to know the right solution. How To Fix Excel Not Recognizing Date Format? The second possibility is that while trying to sort that dates column, all the data get arranged in the incorrect order.

Format date cells in excel not working