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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop excel from dropping the 0 in the beginning of a number? 11
how to show numbers that begin with 0 in excel 2
zero "0" dropping from the beginning of my serial numbers 3
zero suppression on opening .xls file 1
The 0 is dropped in zip codes beginning w/zero (Excell) 5
Excel files saved to H drive are 0 byte size on initial save 12
Export Excel tuncating leading zeros while export to excel from da 1
How do I begin value with the number zero? 2

Back
Top