When I pull things off the internet, Paste Special only allows me to paste
HTML, Unicode Text, or Text. The other Paste Special window is never an
option. Thanks for the thought.

"Bill Martin" wrote:

Have you tried to first format the column to text, and then when you do the
paste, use "Paste Special" and select "values"? Your normal Paste also replaces
the formats as well as the values.

Bill