David,

There are two ways I know-

1) =VALUE(A2)


2) =A2*1


regards,

JohnI

"David Bateman" wrote in message
...
I have copied some a column of numbers from a web page into an excel
worksheet. The "numbers" are reflected as text (alining on the left side
of
the cells). I have tryed formating before and after entering the data.
However if I click on the entries with the mouse and then hit enter they
reflect as numbers....Is there an easier way to do this? I have thousands.

Thank you in advance.

David