Excel 2000 sorting by date problem

[JenniferH]

I have 3 columns in my worksheet, one of which is a date column. M
dates are, for example, 03/01/2001, 04/01/2001 and 03/01/2002.

I want to sort by date, so that they are in the above order, howeve
Excel is sorting them by month and day only. When sorted, they appea
as:

03/01/2001
03/01/2002
04/01/2001

How do I get the 2002 dates to follow the 2001 dates

 

[Frank Kabel]

Hi
are you sure this column is stored as date and not a text?. Try the
following (if one of the dates is in A1)
=ISNUMBER(A1)
this should return true otherwise your dates are text values. You can
convert them to dates using the following
- format the column with the format MM/DD/YYYY
- select an empty cell and copy this cell
- select your column with dates
- goto 'Edit - Paste Special' and choose the action 'Add'

now retry your sorting