• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sorting by Date In Excel 97-2003

Susan Becker

New Member
Hi,

I have an Excel file (97-2003) that has dates. All dates have already been formatted to "date" instead of text, number, etc. The file only has 9000 rows, so it is not anywhere near the limit.

When I go to sort by date oldest to newest, Excel keeps putting 2016 dates ahead of all dates in 2015. 2015 is sorted oldest to newest. I added a line with a future date in 2016 (10/1/16) and it put this line where it should be but kept Jan and Feb dates at the beginning of all data. All dates are formatted to the short date format.

It is a work file thus I cannot upload.

Please help.
 
Back
Top