Converts any value to text.
Syntaxis
VALUETOTEXT(value, [format])Argumenten
valuevereist
The value you want to convert to text.
formatoptioneel
A number specifying the format: 0 for strict (default) or 1 for concise.
The VALUETOTEXT function returns text from any specified value. It is particularly useful for converting numbers, dates, or boolean values into a string format that can be used in text-based formulas or exported data.
=VALUETOTEXT(123.45)→123.45Converts the number 123.45 into the text string '123.45'.
=VALUETOTEXT(TRUE)→TRUEConverts the boolean value TRUE into the text string 'TRUE'.
Select the cell
Click on the cell where you want the converted text to appear.
Enter the formula
Type =VALUETOTEXT( followed by the cell reference or value you wish to convert.
Complete the function
Close the parenthesis and press Enter to see the result.
Format 0 (strict) includes quotes for strings, while format 1 (concise) returns the raw text without additional formatting.