+ Reply to Thread
Results 1 to 3 of 3

Problem sorting Date

  1. #1
    Registered User
    Join Date
    05-31-2007
    Posts
    1

    Problem sorting Date

    Hi,

    I have spreadsheet includes different data in it, and there is date columne with a format Mar 11, 2007
    when I try to sort it by date I get the results like this:

    Mar 1, 2007
    Mar 11, 2007
    Mar 12, 2007
    Mar 14, 2007
    Mar 19, 2007
    Mar 2, 2007
    Mar 20, 2007
    Mar 21, 2007

    as you see the date of Mar 2, 2007 comes after the 19 where it should be comes after the Mar 1, 2007

    can anyone tell whats wrong I'm doing in Sorting the date.?

    Thank you all for your help.

  2. #2
    Forum Contributor kraljb's Avatar
    Join Date
    05-26-2004
    Location
    Illinois
    MS-Off Ver
    2007 (recent change)
    Posts
    256
    Sounds like it's treating it as text as opposed to a date value.

  3. #3
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Assuming your first date is in A1, paste the following into B1

    Please Login or Register  to view this content.
    and copy down. Sort by B1.
    Martin

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1