I usually select the imported column, make sure it if not formatted as text
and then do datatext to columns and when the import wizard opens I just
press finish. That usually works. But I guess it depends on if you have some
extra character baggage from the other program like invisible trailing html
characters (CHAR(160)

--


Regards,


Peo Sjoblom

"Glenda" wrote in message
...
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