Rename the .csv file to .txt

Then open excel, use File|open to open that .txt file.

You can follow the import text wizard to tell excel that this field should be
treated as text.

Maxfli wrote:

When I save a spreadsheet to .csv and it has account numbers "01-15-2000"
Excel automatically saves them as dates. I can Lock the cell, format it as
text, etc. and it has no effect.

I need to use .csv to upload data to my ERP application. If I use an " ' "
in front of the data the upload doesn't read it correctly as just the account
code.

I need to use a "shout out" --- HELP!!
--
Bill

--

Dave Peterson