I am trying to copy and paste eBay auction numbers into Excel, it’s the 2003 version if that is needed. Excel insists on pasting the numbers as 3.43734E11 instead of the 12 numbers from the auction listing. How can it get Excel to paste all 12 numbers?
Try expanding the column first to see if you can see the whole number - Excel truncates numbers that are too long to fit in the default cell width. If that doesn’t work, format the cell as Text and then paste the numbers in. Select the required cells, right-click, select Format Cells and then under the Number tab (the first one) select Text. After that, you should be able to paste the numbers in and have them appear unformatted.
The above is the best advice. For an alternative, just FYI, first type a single-quote into the cell, then paste the number after that. It will then be interpreted as text without having to format the cell.
Another option (I use this one when I’m putting in fixed-length number fields like ISBNs that might begin with a zero) is to set the cell style to “custom” and put in 000000000000 as the format. That will guarantee you 12 digits.
Similarly, paste them in and in the column next to it, put in a text formula -
In cell A1 → Your ebay auction number
In cell B1 → =text(A1,0)
Copy that formula down and it will show all of your values in full.
Nit: It needs to be an apostrophe, not a quote.
That’s probably what was meant by “single-quote”, since " is sometimes called a double quote. But calling it an apostrophe is clearer. Just to go even further, use the following symbol:
’