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
--
dominicb
------------------------------------------------------------------------
dominicb's Profile:
http://www.excelforum.com/member.php...o&userid=18932
View this thread:
http://www.excelforum.com/showthread...hreadid=394635