how to treat string value as a number

[kang]

how to handle string as a number
equivalent to Integer.parseInt or Float.parseFloat as in Java.

Thanks.

 

[Bob Phillips]

have you been given work assignments?

what Excel problem does this relate to?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[kang]

nope.

when I add the values it gives some strange values.