Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Question on sorting dates
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
-----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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting using dates | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
Another question regarding Dates.. | Excel Discussion (Misc queries) | |||
sorting question | Excel Discussion (Misc queries) |