To use this function, choose Calc > Calculator.

Converts a numeric or date/time column or value to a text column. Converting numeric values to text lets you edit and manipulate the values using text manipulation functions.



For number, specify the number or the column of numeric or date/time values.


To convert a numeric column (C1) into a text column, enter the expression TEXT(C1) and store the result in C2.

C1 C2-T
233.4 233.4
45.1 45.1
341.7 341.7
22.56 22.56