I have a column of dates entered as text (each entry is preceded with " ' " [EX: '1/1/1900]). I know I can edit each cell by removing the character; but if the column is hundreds of rows long, How can I do it quickly? I looked at the find/replace feature, but to no avail.

---

Reply from Richard Rost:

Use the DATEVALUE function. That converts text into a date. So if your text is in A1, you would say this in B1:

=DATEVALUE(A1)

This will give you a NUMBER. Just format the cell as a date.

Now AutoFill for the entire column. Then you can copy and paste those VALUES to another column  (or sheet) and that solves the problem.