Forum Discussion
Convert date entered as text to date format
I inherited an excel spreadsheet with dates in a column. They were entered as a text date and I am trying to change it to a true Date field. Formating does not work. I also tried to remove the (')...
Let's say the text dates are in D2 and down.
Select column D.
On the Data tab of the ribbon, click Text to Columns.
Click Next > two times.
In step 3 of the Text to Columns Wizard, select the date format that fits your data.
Click Finish.