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

  • Thread starter Thread starter Mo
  • Start date Start date
M

Mo

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
 
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
 
Back
Top