Excel Import Text file

Posted on 2014-08-19
Last Modified: 2014-08-19
Please note the second column. When I import this into Excel when it gets to the rows where the values begin with 11 Excel tries to convert the value to dates so I get Nov 1, etc. I just want them all to be read is as text fields. How do I get Excel to treat this entire column as text fields?
Question by:rwheeler23
    LVL 16

    Expert Comment

    Try surrounding your text in quotes (i.e. "00-1102"), which would read the entire string as one entry versus multiple entries.

    Also consider converting your .TXT file to a .CSV file and use comma's to separate the columns instead of white spaces. A simple search/replace in Notepad would automate that for you. Once done, just open the CSV file in Excel
    LVL 35

    Accepted Solution

    When you import, you will come across this screen, select text when clicking the column.

    Author Comment

    I have no choice with this import file. It comes from a payroll processor.

    Author Closing Comment

    That was the trick. Thanks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now