sort by date ?

[RaY]

Hi.

I am trying to sort a column of dates in the dd/mm/yyyy date cell
format in order. Using the sort function it seems only to sort by
day then month and ignores year. What Iam getting is :

01/10/2008
01/11/2007
01/12/2008
02/01/2008

And what I need is:

01/11/2007
02/01/2008
01/10/2008
01/12/2008




Any ideas ? Thanks in advance.

Ray.

 

[Bob Phillips]

It sorts fine for me, your dates must be text.

Try selecting the column, then goto Data>Text To Columns, Next the first two
dialogs and on the third select Date from the option buttons.

 

[Niek Otten]

Your cells are probably text, not dates. You can test with the ISTEXT()
function.
If so, do the following:
Copy an empty cell. Select your data. Paste Specoal, chack Add. Format the
cells as date.

 

[RaY]

Thanks . That did the trick perfectly.
tc.

Ray.