Keep quoted numeric characters as text.

[Jay Waddoups]

Is there any way I can keep Excell from converting double
quoted strings of numeric characters to a number when
opening a .csv file?

I have a column where sometimes the text being imported
is something like "001". I need to load it as text '001'
instead of as a number 1. If I change the column to text
after opening the file, the leading zeros are still
missing.

 

[JE McGimpsey]

In MacXL you can open it directly with Text Import wizard. With WinXL
you need to change the extension (say, to .txt) first. Then set the
column to Text in the third pane of the wizard.

 

[Peo Sjoblom]

There is a way to open csv files without renaming them, data>import external
data>import data,
select all files under files of type, then either double click or select and
click open the csv file.
That will trigger the text import wizard

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)