-----Original Message-----
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
.
When formatting your cells in Excel, try the GENERAL
format selection and see if that helps. Mine sorts
correctly when set that way and using your example. Greg
|