You're getting the results of a *Text* sort, meaning your dates are*not*
true XL dates, but simply text representations of dates.

To correct this situation, you must convert them to XL readable dates
*before* you perform the sort.

Select your column of 'dates', then:

<Data <Text To Columns <Next <Next,
Under "Column Data Format",
Click in "Date",
And make sure "MDY" is showing in the box.
Then <Finish.

NOW ... try your sorting!
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================





"Spin" wrote in message
...
Hi,

I am having a nightmare of a time trying to sort a date column in a
spreadsheet. The column is made up of dates as shown below and the dates
will sort in descending order all the way out to the year due to some kind
of limitation. Here is my column:

9/28/2005
9/28/2004
9/27/2005
9/27/2004
9/26/2005
9/26/2004

See what I mean??? I want it to look like this:

9/28/2005
9/27/2005
9/26/2005
9/28/2004
9/27/2004
9/26/2004

Thanks. :-)

--
Spin