• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

Excel Import Text file

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?
0731-GL-REPORT.TXT
0
rwheeler23
Asked:
rwheeler23
  • 2
1 Solution
 
ThinkPaperCommented:
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
ex:
07/31/2014,00-1102,0,49180.6
07/31/2014,00-1102,0,992.59
0
 
KimputerCommented:
When you import, you will come across this screen, select text when clicking the column.
formatcolumn.PNG
0
 
rwheeler23Author Commented:
I have no choice with this import file. It comes from a payroll processor.
0
 
rwheeler23Author Commented:
That was the trick. Thanks.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now