| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Text values to numeric values
Is there a formula to convert a text value in a cell to a numeric value? Thanks, Jayveejay -- jayveejay ------------------------------------------------------------------------ jayveejay's Profile: http://www.excelforum.com/member.php...fo&userid=5043 View this thread: http://www.excelforum.com/showthread...hreadid=394635 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| query about VALUE function | Excel Worksheet Functions | |||
| convert text to numeric vba add-in? | Excel Worksheet Functions | |||
| Database text converted to numeric | Excel Discussion (Misc queries) | |||
| How to use an array or matrix to return text vs. numeric values | Excel Worksheet Functions | |||
| convert a number in Excel from numeric to text, i.e. "1" to "one" | Excel Worksheet Functions | |||
Linear Mode
