ISBN problem

  • Thread starter Thread starter digital21st
  • Start date Start date
D

digital21st

Hi guys

I'm having a problem with my product catalogue with my online store.
download the catalogue to .csv file and open it in excel. When I ope
the file it removes the zero from the ISBN number. (eg 07654321 become
7654321). This is becoming a big pain.
Is there anyway I can prevent excel from automatically doing thi
 
Hi

Try renaming your file from csv to txt. WHen you try to open it in Excel,
the Text Import Wizard will start. As you click through the options, one of
them should allow you to tell Excel what format the data is in - and you can
declare that it is a text field. This will bring in the whole field as
text - and retain the initial 0.

Andy.

"digital21st" <[email protected]>
wrote in message
news:[email protected]...
 
Back
Top