Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have some problem with database | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |