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

Thread: Date conversion/sorting problem

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a voluminous spreadsheet that I need to sort by date. The problem is how the dates are presented. For example: January 2, 2002 is presented as 1022002. October 2, 2002 is presented as 10022002. Essentially, dates are entered as integers, not in a form which Excel recognizes as dates. Do you know of a way that I could convert the integers to dates?
    Thanks

    Any assistance would be greatly appreciated.

    Frank Patrinicola

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    For text representation of date values listed in column A begining at cell A1 enter the formula...

    =TEXT(A1,"0-00-0000")+0

    ...into B1 and fill down. You can then use Copy/Paste Special... Values to overlay the column A values.

    ...Or, just sort on the new column B values.

    [ This Message was edited by: Mark W. on 2002-04-24 13:08 ]

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
  •