I was given an Excel document.
In the data there is a column of dates formatted 5/20/2014. Half the data in that column is formatted as a date. The other half is formatted as text. When I try and format the entire column as a text the cells formatted as dates become their numeric equivalent (integers). If I try and format the entire column as a date, the cells formatted as text stay text values until I double click the cell and hit enter; then they become formatted as a date.
How do I change the format from text to date without having to double click in thousands and thousands of cells?