I am having a problem doing the following:

Save a mobile telephone number in a spreadsheet
Cell is formatted as text so the zero appears ie 0423 176 323

Then save as CSV. Close the CSV and then reopen and the 0 disappears.

I have tried using Excel 2000 and Excel 2003 and both doing the same thing.

Does anyone know how I can get the CSV file to retain the leading zero?

Cheers!