excel 2003

C

Cobolace

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.
 
G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XLL ('C' extension) question 2
Excel 2003, cannot import quoted fields with separators inside 2
Cell content surrounded by quotes when saving as tab delimited for 2
Excel Save As Options 2
Unicode text and carriage returns 4
Converting Tab Delimited Text File to A Comma Delimited Text File 1
Excel 2003 inserts quotes when saving SS as text and comma is pres 1
Excel Save As... text with special characters 2

Top