To use this function, choose .
Converts a text column containing numbers into a numeric column. After you convert a column of numbers into a numeric column you can perform mathematical operations on the data.
VALUE(text)
For text, specify the text or the text column.
To convert a text column into a numeric column, enter the expression VALUE(C1) and store the result in C2.
| C1-T | C2 |
|---|---|
| 233.4 | 233.4 |
| 45.1 | 45.1 |
| 341.7 | 341.7 |
| 22.56 | 22.56 |