excel 2003
 

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.

excel 2003
 

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
--
Gary's Student


"Cobolace" wrote:

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.