LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Excel heavy user
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sorting using dates Tpason Excel Discussion (Misc queries) 1 January 14th 05 09:21 PM
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 08:43 PM
I get wrong dates when i paste from a different sheet into a new s mmollat Excel Discussion (Misc queries) 2 January 6th 05 07:35 PM
Another question regarding Dates.. Anthony Slater Excel Discussion (Misc queries) 2 December 20th 04 03:31 PM
sorting question Brian Excel Discussion (Misc queries) 4 November 28th 04 12:30 PM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"