I am copying data into a worksheet from another program. Excel sees the
numbers as text and I get an error message.
I would like to highlight the entire worksheet ( via clicking on the area
between the A and the 1 in the cell/row identifier upper left corner) and
change all of the data to numbers. It doesn't work.

The only method I've found to do this conversion is by actually clicking on
the error warning box - this method doesn't work in a macro. Is there
another way?

Does anyone have other suggestions for doing this?

--
Glenda