Hello, I have a huge list of data that was exported into a spreadsheet. The dates appear to be in text in the following format:
12/11/08 06:37
12/11/08 16:33
12/12/08 09:35
12/12/08 11:45
How can I quickly covert all of these values to dates? If I enter the cell and click enter it gets converted to a date but thats tedious for thousands of rows of data.
Any suggestions?
- Thanks
12/11/08 06:37
12/11/08 16:33
12/12/08 09:35
12/12/08 11:45
How can I quickly covert all of these values to dates? If I enter the cell and click enter it gets converted to a date but thats tedious for thousands of rows of data.
Any suggestions?
- Thanks