To use this function, choose .
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.
TEXT(number)
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 |