Re: How to COnvert text string to number

[Andy]

Mike

Make sure the 'empty cell' you copy is not formatted as text.

Andy.

Mike

Copy an empty cell.

Select your range of "numbers".

Paste Special>Add>OK>Esc

Gord Dibben Excel MVP - XL97 SR2 & XL2002

 

[timtak]

Thanks

Thanks.

I did not know the meaning of "special paste > add"

But it would be nice to know how to do the same with an excel function.

Is there something like
=num(a1)
which would turn a string, even a string, even a null string into ta number?

There is no need to answer my post since I used the paste function suggested.
But to say thank you and for the sake of future viewers I leave you all with this
question.

Thanks again,
Tim

 

[Ron de Bruin]

Hi

=A13*1

With trailing negatives

=IF(ISNUMBER(A25*1),A25*1,IF(A25="","",-LEFT(A25,LEN(A25)-1)))

More options are in this Beta Add-in
http://www.rondebruin.nl/datarefiner.htm

 

[Guest]

I just use the following

If my 'text' number is in A1

in B1 I have the formula

= A1 + 0

works like a charm..

 

[Guest]

If you know the target cell(s) can be converted to a number (i.e. it is not a
mix of text and number), you can simply use the value function: VALUE(C2) if
C2 contains your number in text format.