ISBN problem

[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

 

[Guest]

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]...

 

[digital21st]

You star! thanks mate

Paul