Text number to number value for calculating

D

ddiebold7

How do you convert a text number format "51" to number 51 that I can use
for calculations. Quotes used to illustrate that it is in text format.
*Please email me at [email protected].* I am stumped. *Please
Help!*

Dave Diebold
 
S

sanskar_d

ddiebold7 said:
How do you convert a text number format "51" to number 51 that I can use
for calculations. Quotes used to illustrate that it is in text format.
*Please email me at [email protected].* I am stumped. *Please
Help!*

Dave Diebold
Click to expand...


Hiiii!

It a very simple trick.
Simply multiply the number (in text format ) by one (in the adjecent
cell or column).
 
B

bj

simce there are often spaces associated with Text numbers I often use
something like
=value(trim(A1))
if the number is in Cell A1
 
Top