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:
[Quoted Text] > 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.
|