Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
How can i paste a 16 digit number in a excel worksheet? | Excel Discussion (Misc queries) | |||
How do I stop last number from changing to a 0 in excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |