It sounds as if (for some cells at least) you've got text, rather than
dates. Format the Cells and see whether they will change to 24 July 08, for
example. If the Format doesn't change the display, the contents are text,
not dates, hence they won't sort correctly.
--
David Biddulph

"Pammy" wrote in message
...
this is excel 2003

"Pammy" wrote:

I have a column with a short date formatted: 1/1/08, 10/20/07, showing
this way.

Question: It does not sort correctly, I am finding some 12/02/07 example
mixed in with 1/20/08 and as I look down through the worksheet there are
several 07 mixed in with the 08, how do I correct this?

Thanks,