Thanks a lot.

Jason

"Peo Sjoblom" wrote:

What happens if you test with a formula

=ISTEXT(A2)

if it returns TRUE the dates are text, if so, copy an empty cell, select the
dates
and do editpaste special and select add, then reformat the dates as mm/dd/yyy
or dd/mm/yyyy depending on whether dates are US or UK format
If that does nolt help you probably have trailing or leading spaces as well,
then you can first do an editreplace and replace a space with nothing

Regards,

Peo Sjoblom

"Excel heavy user" wrote:

After I download data from a database, the data in the date column is in date
format, as for example, "11/02/2004". To make sure they are in date format, I
format them again. Then I tried to sort the date in an ascending order, it
doesn't work. It did some sorting work, but it put November dates right after
January dates, and then Feb, Mar.... I guess Excel doesn't really take this
column of data as dates.

Any help is appreciated.

Jason