convert text to date in excel?

best answer
To convert a text date in a cell to a serial number use the DATEVALUE function. Then copy the formula select the cells that contain the text dates and use Paste Special to apply a date format to them. Follow these steps Select a blank cell and verify that its number format is General.