Hi,
My ultimate goal is to sort some data in an excel spreadsheet imported from a csv file in date (chronological) order. However I've established I cant do this at the moment as although the contents of the cell is for example 01/07/2010 it is in a text or general format and not date format. So when I sort I get a list sorted by first digit only.
Is there a formula that would convert the general / text in a cell for example 01/07/2010 to a date format which could be then sorted into chronological order?
My ultimate goal is to sort some data in an excel spreadsheet imported from a csv file in date (chronological) order. However I've established I cant do this at the moment as although the contents of the cell is for example 01/07/2010 it is in a text or general format and not date format. So when I sort I get a list sorted by first digit only.
Is there a formula that would convert the general / text in a cell for example 01/07/2010 to a date format which could be then sorted into chronological order?