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.

Syntax

VALUE(text)

For text, specify the text or the text column.

Example

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