Hi, I'm having a problem copying and pasting something from the internet. When I paste, I use "Paste Special" and pre-select text for this column. Sometimes it works and at others it doesn't.
Here is how it appears on my worksheet when it gets pasted; 2.01002E+13
Here is how it appears above in the address bar when I click on the cell: 20100187407610
If I copy the number from above and try to paste it in the cell it rejects it and gives me the same result; 2.01002E+13. If I click on the cell and try to format it it gives me a font to choose from instead of the usual format window. What can I do to get correct the cell once it has gotten screwed up?