View Single Post
  #3   Report Post  
sanskar_d
 
Posts: n/a
Default


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