How to Troubleshoot If Excel Not Recognizing Date Format? - www.office.com/setup
If you maintain the data but all of a sudden Excel not recognizing date format then all your data gets wasted. If in case, you can not be able to fix the issue then you can contact the customer care of MS Office via office.com/setup . In this situation, Excel Not Recognizing Date Format when you copy or import data into Excel and then all your date formats goes wrong. If Excel recognizes the wrong dates and then all your days and months get switched. Solution To Fix Excel Not Recognizing Date Format: Text To Columns: First, you should highlight the cells which having the dates and then select the complete column. Here from the Excel ribbon, you should click on the Data menu and then select the ‘Text to columns’ option. Now, in the opened dialog box you should select the option of ‘Fixed width’ and then just click on the Next button. In case, there are vertical lines with arrows present then this is known as column break lines. Now, go through the data section and just double click on