No, you are wrong. No need to change the file extension.
Try it.. Do dataimport external dataimport data,
in the dialogue box files of type select all files or type *.*
find the csv file and open it and the text import wizard will
start.

--

Regards,

Peo Sjoblom

"David McRitchie" wrote in message
...
Sounds like it might be helpful as... You only have a choice
if you change the file extension to .txt instead of .csv

This way another program could generate the .csv file and
it could be opened in Excel without intervention. Of course
it would be nicer if the entire column were text so that new
entries added would be text as well (I don't put too much
reliance on the Extend Formulas and Formats).
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Peo Sjoblom" wrote in message ...
You can open the csv file using
dataimport external data, select all file types and import the column
as
text.

"alex robkin" wrote in message
...
if you create the csv file with ="00300",This will display initial
zeros!!!

include the equal signs surrounded by quotes....