Your "dates" are sorting like they're text....which means...those values are
text, not dates.

Try this:

Select an empty cell.
EditCopy

Select your range of values
EditPaste Special
Check: Add
Check: Values
Click the [OK] button

That should convert your text-that-looks-like-dates into actual dates.

Now try sorting them

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Spin" wrote:

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