Converting text to number - how??
 

Hi

I have a column of numbers in text format - I need to change them to
number format

When I goto Format -cells to change - it does not work
Is there another way to change?

Thanks

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany

yahoo wrote:
Hi

I have a column of numbers in text format - I need to change them to
number format

When I goto Format -cells to change - it does not work
Is there another way to change?

Thanks

Format as number of general, copy an empty cell, select all data and do
editpaste special and select add


Regards,

Peo Sjoblom

"yahoo" wrote:

Hi

I have a column of numbers in text format - I need to change them to
number format

When I goto Format -cells to change - it does not work
Is there another way to change?

Thanks

You have to make another column and use the formula +value(extcell)