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