sort by date ?

  • Thread starter Thread starter RaY
  • Start date Start date
R

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.
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top