How to sort rows based on their date?

[dbwoods11]

Column A is dates. Column B is a number value. The dates (format: 31-Jan-2013) are out of order but I want them in order. I have tried to make a list then organise acending /decending order. It sorts them buy them by the day ex: 1-may-1982, 3-dec-2010, 8-dec-1975, 9-may-2012.

Hopefully you can understand what I'm asking. I would like them to appear in cronological order. Any suggestions?

Thanks

[FDibbins]

IF your dates are actually dates, they should sort fine, so that leads me to believe that they are actually text that just looks like dates? test with =isnumber(cell_ref) FALSE means they are text

To correct this, select the entire range of "dates", go into text-to-columns (under data) select "delimited", enter until you get to the window with "column data format", select date

[dbwoods11]

Wow you're good. It worked. Thanks

[FDibbins]

Happy to help and thanks for the feedback