If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Strange problem with different networks. | Adam | General Discussion | 1 | March 13th, 2005 10:17 PM |
IE6 & Outlook Problem (Strange Problem)! | KW | Outlook Express | 4 | February 1st, 2005 08:31 AM |
Reinstalling OE... | KAR | Outlook Express | 24 | August 21st, 2004 06:52 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |
word error | mac | General Discussions | 1 | May 6th, 2004 08:14 AM |