How do i convert these from text to date??
Posted on 2011-03-22
Using Excel 2007; i've imported a huge CSV file into Excel.
There is a column with thousands of 'date' entries, but for some reason Excel is not seeing them as dates.
They are entered like this:
19/01/2011 02:45:01 pm
19/01/2011 02:42:35 pm
19/01/2011 02:40:14 pm
19/01/2011 02:39:23 pm
19/01/2011 02:39:08 pm
19/01/2011 02:34:52 pm
19/01/2011 02:29:55 pm
19/01/2011 02:20:19 pm
I'm trying to sort them by date in a pivot table, but they won't sort correctly, because Excel doesn't see them as dates.
How do I convert them to date fields? I don't need the 'second', but I do need the day, month, year, and then the time (03:50, 04:01, etc)