View Single Post
  #1   Report Post  
GLS
 
Posts: n/a
Default Re-formatting of dates from Excel to CSV

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