numbers as text?

[David Bateman]

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

 

[JohnI in Brisbane]

David,

There are two ways I know-

1) =VALUE(A2)


2) =A2*1


regards,

JohnI

 

[Tom Ogilvy]

format the cells as general

go to an empty cell and enter the numeral 1
select that cell and do edit=>Copy

select the troublesome cells and do
Edit=>PasteSpecial and select multiply.

This should convert them back to numbers.