Question: how to change date format in excel from text to date?
Answer: Enter =DATEVALUE(
Click the cell that contains the text-formatted date that you want to convert.
Enter )
Press ENTER, and the DATEVALUE function returns the serial number of the date that is represented by the text date. What is an Excel serial number?