excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm importing ascii delimited text file into excel. Cols are delimited by
commas and
text is surrounded by double quotes. No matter what I do, numbers inside ""
are treated as numeric instead of text, even when followed by spaces before
the
closing double quote.

According to all help instructions, those numbers should act like text.
Ex. "00001234 " comes out as 1234. Why? It' driving me crazy.
 
1. make sure the file is not .csv it should be .txt
2. this should invoke the wizard when you try to open it.
3. tell the wizard it is comma separated
4. when the wizard asks you about "00001234 " be sure to specify text and
not general
 
Back
Top