GLS,

It's probably writing the data to the csv as it appears in the sheet. It's
the reopening with Excel that's using a different format. The next question
is: Is the csv for some other application? If so, you're good to go. To
see exactly what's in the csv, open it with NotePad, or any text editor.
There's more on text files and Excel at www.smokeylake.com/excel.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"GLS" wrote in message
...
When I save an Excel worksheet as a CSV file the dates are re-formatted
from
04/11/2004 to 4/11/2004 (British style Date ddmmyyyy). This doesnt happen
immediately on saving but when the CSV file is closed and then reopened.

Any suggestions how I can prevent it dropping the leading zero?

Many thanks

GLS
--
GLS