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 |