The problem arises if the copied text begins with =, - or =. In such cases, Excel thinks the text is a formula and tries to evaluate it. The initial single quote tells Excel that what follows is to be interpreted as text. And pre-formatting the cell as text tells Excel that any value placed in that cell will be displayed and stored as text.
That solved it!
Thanks,
Bob C.