software

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 quot;quot;
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. quot;00001234 quot; 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 quot;00001234 quot; be sure to specify text and
not general
--
Gary's Studentquot;Cobolacequot; wrote:

gt; I'm importing ascii delimited text file into excel. Cols are delimited by
gt; commas and
gt; text is surrounded by double quotes. No matter what I do, numbers inside quot;quot;
gt; are treated as numeric instead of text, even when followed by spaces before
gt; the
gt; closing double quote.
gt;
gt; According to all help instructions, those numbers should act like text.
gt; Ex. quot;00001234 quot; comes out as 1234. Why? It' driving me crazy.