disable removal of leading zeroes

[Tom Smith]

I need to import an excel spreadsheet, saved as a comma
seperated value format (CSV). It must have a column of
cells with the following text: 001

I was able to do this two weeks ago by inserting an
asterik beforethe zeroes and then cell formatting
as "text". HOwever, this does not work anymore. The
program removes the zeroes now anyway, making my
bookkeeping program unable to read the spreadsheet. How do
I solve this problem? Please send answer directly to my e-
mail: (e-mail address removed). Thanks.

Tom

 

[Ken Wright]

Change the extension to .txt and then bring it in via the Text Import Wizard. This will allow you
to specify the formatting of each column if you so wish, and you can choose text for this one.