I have a column with hundreds of dates and times that look like this (year, month, day and then time):
2012-03-28 12:03:36
2012-03-28 12:35:02
and so on
so its the year, month, day and then the time.
I cant get Excel to recognize this as a date and time so I can sort the data currently its newest to oldest so I want to reverse the order and am trying to use the data-sort command but Excel doesn't seem to recognize it as a date and time. Is there a way to get Excel to recognize this as a date and time?
thanks, Roger
Bookmarks