If you are using Data - Sort and this is not working in your column,
then it may be that the dates are stored as text. To make sure that
Excel views them as dates, convert them using the DATEVALUE() function
in another column.

For instance if the dates are in A1:A10, in cell B1 enter
=DATEVALUE(A1), then fill this down to B10. Then Excel will have a set
of date values that can be formatted as DD/MM/YYYY, and you should
then be able to sort them.

HTH

On Nov 1, 10:53*am, wrote:
I've read around and no one seems to answer just the straight
question on how to sort by date in a column.

I wrote a post before and was answered and confused me more than
before.

All I want to do is sort a series a dates in order. The dates are in
the form DD/MM/YYYY. This is all in one cell. So how would I sort this
in chronological order.

Thank you