Stop Excel from dropping the 0 in the beginning of a number
 

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

Stop Excel from dropping the 0 in the beginning of a number
 

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

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

Stop Excel from dropping the 0 in the beginning of a number
 

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

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

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