How to Control Cell Formatting on Imported (CSV) Data

I discovered a very useful "Library" app (Libib) which is very simple and easy to use to catalog a modest collection of books. My question is this... Some of the older books (pre-1967) had one less digit than the original ISBN standard, so a leading zero was added to create the new ISBN number. When I export the data to Excel, the leading zero is discarded, except for a very few older books that had a single alpha character added to the (right) end. The leading zero is in the CSV export file, how can I prevent Excel from removing it - I tried changing the cell format but it appears that the zero was already removed when the file was opened by Excel. The problem is that if I try to look up a book w/o the leading zero, the database can't fine it - the leading zero is a significant digit and, if it is corrupted on export, this impacts proper identification of quite a few older books.

Try formatting the desination cells as Text before importing the csv file.