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

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
 
M

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 do I stop Excel from dropping leading zeros? 9
Export Excel tuncating leading zeros while export to excel from da 1
zero suppression on opening .xls file 1
How to display zeros at the beginning of a number? 5
Converting xls to CSV file - dropping leading 0s 1
Need 7 digit number with differnt number of leading zeros 10
transfertext command is dropping leading 0's how to stop? 2

Top