So, I have a worksheet with data pasted in from a Database. I have, for
instance, a column that is all numbers stored as text. I'd like to
convert all the cells at the same time. OR, I would like excel to
ignore the error for all of them.

Forget telling me to format the column as a number. It doesn't work.
Thanks,

Rob