In an un-used cell enter 1 (as a true number). Copy this cell and
paste/special/multiply onto the cells you would like to convert.
--
Gary''s Student - gsnu201001


"Janet" wrote:

I have copied a column of numbers to excel and now cannot apply any formulas
because the numbers are text. How can I convert the text to numbers?
Thanks.
--
Janet