View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default How can I stop csv files converting 19-05-53 to 19/05/1953

We save all our stock numbers in a custom format (00-00-00)

We need it in this format to use with our software which imports csv files &
reads the stock number.

When I save the spreadsheet as a csv file it converts 19-05-53 to 19/05/1953

Is there anyway to stop this?

Many Thanks