Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Dates not sorting Properly in Excel

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,
    I have a colutmn of dates that are part of a table. The data is input via a form (Thanks to Audiojoe for the spinbutton code) and then sorted.

    The problem seems to be that the dates are only sorted on the day part of the data (format is dd/mm/yyyy) Therefore the 16/04/2002 is coming before 25/03/2002.

    This little nuance is wrecking my home made task / to-do list app !!

    Any help greatly appreciated.

    Regards
    Darren

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It appears your dates are entered as text. You will need to convert them to numbers for Excle to sort them properly. Easiest way is to multiply each date by 1 and reformat. Place the number 1 in a empty cell, copy it, and then do a paste special Multiply on your date column.

    [ This Message was edited by: lenze on 2002-03-25 09:32 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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