Hi,

I am pasting columns from one sheet to another. Some columns are
formatted as text, even though they only contain numbers. Other columns
do contain text. Is there a generic way to paste columns so that if
they are numbers, they are pasted as numbers, but if they are text
strings, they are pasted as text?

Thanks