rwheeler23
asked on
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
0731-GL-REPORT.TXT
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have no choice with this import file. It comes from a payroll processor.
ASKER
That was the trick. Thanks.
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
07/31/2014,00-1102,0,992.5