Rename your .csv file to .txt.

Then when you open the .txt file, you'll get the import wizard where you can
specify the format of each field--including Text for this field.

HarCo wrote:

When I open a csv file in excel any preceding '0' will disapear. How can I
see the data exactly as it is in the csv\text file? (e.g. if my data contain
telephone numbers with area code that has preceding '0' it will be removed).

--

Dave Peterson