Text values to numeric values

J

jayveejay

Is there a formula to convert a text value in a cell to a numeri
value?

Thanks,

Jayveeja
 
D

dominicb

Good afternoon Jatveejay

Yes there is. Say your numeric value is in A1, in B1 the formula:

=VALUE(A1)

will show the number as a value. If you wanted to convert a number in
its cell from a text number to a value number, ie., not use a formula
in a different cell you would need a VBA routine.

HTH

DominicB
 
Top