Is there a formula to convert a text value in a cell to a numeric value?
Thanks,
Jayveejay
Is there a formula to convert a text value in a cell to a numeric value?
Thanks,
Jayveejay
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks