To use this function, choose Calc > Calculator.

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.



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