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.

Syntax

TEXT(number)

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

Example

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