Text number to number value for calculating
 

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 .* I am stumped. *Please
Help!*

Dave Diebold


--
ddiebold7
------------------------------------------------------------------------
ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237
View this thread: http://www.excelforum.com/showthread...hreadid=378475

=INT("51")

or if cell A1 contains "51", then =INT(A1)


Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=378475

ddiebold7 Wrote:
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 .* I am stumped. *Please
Help!*

Dave Diebold


Hiiii!

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


--
sanskar_d
------------------------------------------------------------------------
sanskar_d's Profile: http://www.excelforum.com/member.php...o&userid=24217
View this thread: http://www.excelforum.com/showthread...hreadid=378475

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

"ddiebold7" wrote:


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 .* I am stumped. *Please
Help!*

Dave Diebold


--
ddiebold7
------------------------------------------------------------------------
ddiebold7's Profile: http://www.excelforum.com/member.php...o&userid=24237
View this thread: http://www.excelforum.com/showthread...hreadid=378475