I have followed all the instructions regarding importing csv files into
Excel to keep the leading zeros, but it is still not keeping the zeros.

I have saved the file as a text file, then imported the data using the
wizard, changing the relevant columns to text. The data will import
correctly and looks good. However, if I then save the file as csv,
close it down and reopen it, I have lost all the formatting again.

I need to open the file in Excel to put headings on the columns, I then
need to save it as a csv as this is the format required by the client.

Can anyone help? As far as I can see, I am doing everything required,
but still losing the leading zeros!!!

Thanks