Rename the file a .txt file. You'll get a wizard when importing. That enables you to define the field type.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Steve" wrote in message ...
| 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