What is the difference between a "real" date and some other kind of date? I
have both 2000 and 2007, and in neither will dates sort properly. I have used
the dropdown box that lets you select the date format. I type in, for
example, "6/1" and it converts it to "1-Jun". When I sort, I will get some
dates correctly sorted; other dates will be out of sequence. This can include
things like some of the June dates where they should be and others mixed in
with October and December. I have tried using "Custom" rather than date, but
that doesn't help.

"Gord Dibben" wrote:

If real dates, DataSortDescending


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 08:21:01 -0800, Todd wrote:

I have a "date" column in my spreadsheet. Is there a way to sort this column
so that the dates are ordered (from earliest to present)? Thanks!! Todd