Its the formatting changes to plain text that you foolishly paste in that gets me. Paste in a phone number, lose the leading zero. Paste in a long number and get something like 87687767E10.
I've seen so many issues with data caused by people being caught out by this.