How can I stop csv files converting 19-05-53 to 19/05/1953

S

Steve

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
 
N

Niek Otten

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

| 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
 
D

David Biddulph

I think you'll find that it has saved it as 19-05-53 in the csv file (read
it with something like Notepad to see), but the problem occurs if you let
Excel open the csv file. If you merely want the csv file for some other
application to use, you should be OK. If you want to read it back into
Excel, then follow the suggestion to name the file as txt, not csv.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top