Rename your .csv file to .txt and when you import it, you can tell excel to
treat the field as text.


Floridagal wrote:

I am opening a common delimted file in Excel and formating 2 fields as "text"
to retain leading zeros. They appear correctly in Excel. I then need to
save as a "csv" file and retain the leading zeros. How can I do this? The
zero's always drop off in the csv file when retrieved again in excel.

TIA

--

Dave Peterson