Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I stop csv files converting 19-05-53 to 19/05/1953
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I stop csv files converting 19-05-53 to 19/05/1953
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. -- David Biddulph "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Stop Explorer from Opening Online Excel Files | Excel Discussion (Misc queries) | |||
Sharing read-write Excel 2003 files | Excel Discussion (Misc queries) | |||
Temp files causing performance degradation | Excel Discussion (Misc queries) | |||
Cannot access read-only documents. | Excel Discussion (Misc queries) | |||
Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) |