ISBN problem
 

Hi guys

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


--
digital21st
------------------------------------------------------------------------
digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=492747

ISBN problem
 

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"
wrote in message
...

Hi guys

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


--
digital21st
------------------------------------------------------------------------
digital21st's Profile:
http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=492747

ISBN problem
 

You star! thanks mate

Paul


--
digital21st
------------------------------------------------------------------------
digital21st's Profile: http://www.excelforum.com/member.php...o&userid=29575
View this thread: http://www.excelforum.com/showthread...hreadid=492747