+ Reply to Thread
Results 1 to 4 of 4

Made big error importing text file with dates

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010, Excel 2007
    Posts
    57

    Made big error importing text file with dates

    I imported many text file to excel for example one column has date formated in the text file itself as 080911 which is August 9, 2011

    My problem is when I imported to excel the leading zero's are droped is there a way to correct without importing all the files again.

    80911 when I format as date results in 7-10-2121.

    the lengths are all the same 6 character.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Made big error importing text file with dates

    hello
    select all those dates ( 6 digits)
    go to data
    - text-to-column
    delimeted
    choose date...
    choose your kind of format MDY,YMD etc.

    hth
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    06-07-2012
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010, Excel 2007
    Posts
    57

    Re: Made big error importing text file with dates

    All I had to do was format to general and text-to-column works like a charm

    Thanks again

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Made big error importing text file with dates

    nice to hear that.

+ 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