Sort by Date

[ashher]

Hi I am trying to sort the values in a column by date, but it is not working.


The column is in following format.


01APR2009:06:21:34


Thanks

Ashher

 

[Hui]

Are the dates numbers or text ?

Click on the , button if it shows a number it's a number

If it doesn't change it's text

 

[oldchippy]

asher,


Another approach for testing for text is to use


=ISTEXT(A1) if the result is TRUE then it is. Looking at the sample posted there is a semi colon between the date and the time, which indicates that is could be.


If that is the case then in the adjoining column


=LEFT(A1,9)+0+RIGHT(A1,8)+0 and custom format the cell to dd mmm yyyy hh:mm:ss then drag downwards - you can now sort by this column