Results 1 to 4 of 4
  1. #1
    alanbraly
    Guest

    Converting text string to date format (Excel 2000)

    I have a long list (prohibitively long, ~30,000+ entries) of dates that were, for some reason, entered as eight digit strings, i.e. 01/30/1984 is entered as 19840130. Is there a function or an easy way to have Excel switch between the text string to the slash form, so that my list will be in the 01/30/1984 form? Thanks.

    Alan

  2. #2
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Converting text string to date format (Excel 2000)

    Select the column with the date values in.
    Then select from the menu's DATA then DATA TEXT TO COLUMNS.
    select delimited, clear all options
    then next
    then select date with the setting YMD

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Converting text string to date format (Excel 2000)

    If you date string is in A1, try <pre>=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))</pre>

    Andrew C

  4. #4
    alanbraly
    Guest

    Re: Converting text string to date format (Excel 2000)

    Thanks guys. I tried Mario's suggestion first, and that worked like a charm.

    Alan

Posting Permissions

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