software

I found this same question on a Jan. 27 post, but my response there was too
late so I am posting my experience again. The fix did not work for me....
This is exactly the problem I have in trying to save ISBN numbers which
often begin with a zero. I have tried all three methods you have suggested.
Once the text in the column appears correct, I save it in the xls format,
and can open it in excel correctly. But then I save it into the tab
delimited.txt file. When I open the text file in wordpad, I can see the
numbers are fine, with the leading zero correctly in place. Then I open
the file again in excel, and the zeros have been dropped. This is a
problem, because I must upload my books in a tab delimited file to Amazon,
but the zeros disappear, so they don't load my books.
Mo

--
Moira Hoogeveen
Fossil Books
Toronto, ON Canada
If the leading zeroes are there when you open in Notepad, then they should
be able to upload correctly to Amazon.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Moquot; gt; wrote in message
. ..
gt;I found this same question on a Jan. 27 post, but my response there was too
gt;late so I am posting my experience again. The fix did not work for me....
gt; This is exactly the problem I have in trying to save ISBN numbers which
gt; often begin with a zero. I have tried all three methods you have
gt; suggested.
gt; Once the text in the column appears correct, I save it in the xls format,
gt; and can open it in excel correctly. But then I save it into the tab
gt; delimited.txt file. When I open the text file in wordpad, I can see the
gt; numbers are fine, with the leading zero correctly in place. Then I open
gt; the file again in excel, and the zeros have been dropped. This is a
gt; problem, because I must upload my books in a tab delimited file to Amazon,
gt; but the zeros disappear, so they don't load my books.
gt; Mo
gt;
gt; --
gt; Moira Hoogeveen
gt; Fossil Books
gt; Toronto, ON Canada
gt;
Thanks, but that is my point. The leading zeros are there, but Amazon does
not accept the file, and when I see the quick fix file that they return to
me, the leading zero is gone. I have tried to solve this with their help,
but nothing works. So far...
Mo

quot;Anne Troyquot; gt; wrote in message
...
gt; If the leading zeroes are there when you open in Notepad, then they should
gt; be able to upload correctly to Amazon.
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;Moquot; gt; wrote in message
gt; . ..
gt;gt;I found this same question on a Jan. 27 post, but my response there was
gt;gt;too late so I am posting my experience again. The fix did not work for
gt;gt;me....
gt;gt; This is exactly the problem I have in trying to save ISBN numbers which
gt;gt; often begin with a zero. I have tried all three methods you have
gt;gt; suggested.
gt;gt; Once the text in the column appears correct, I save it in the xls format,
gt;gt; and can open it in excel correctly. But then I save it into the tab
gt;gt; delimited.txt file. When I open the text file in wordpad, I can see the
gt;gt; numbers are fine, with the leading zero correctly in place. Then I open
gt;gt; the file again in excel, and the zeros have been dropped. This is a
gt;gt; problem, because I must upload my books in a tab delimited file to
gt;gt; Amazon,
gt;gt; but the zeros disappear, so they don't load my books.
gt;gt; Mo
gt;gt;
gt;gt; --
gt;gt; Moira Hoogeveen
gt;gt; Fossil Books
gt;gt; Toronto, ON Canada
gt;gt;
gt;
gt;