Syntax
VALUETOTEXT(value, [format])
| Parameter | Description |
|---|---|
| value | Parameter of the VALUETOTEXT function. |
| [format] | (Optional.) Parameter of the VALUETOTEXT function. |
Examples
Convert number to text
Formula
=VALUETOTEXT(12345)
Returns "12345" as a text string. The value is left-aligned in the cell and treated as text for functions like LEFT, MID, etc.
Show formula result type
Formula
=VALUETOTEXT(TRUE)
Returns "TRUE" as text. Unlike T() which returns empty for non-text values, VALUETOTEXT converts everything to its text form.
Quoted format
Formula
=VALUETOTEXT("Hello", 1)
Returns '"Hello"' — with format argument 1, text values are wrapped in quotes so you can distinguish text from numbers in output.
Common Errors
#VALUE!
Occurs if the format argument is not 0 or 1.
Tips
Format 0 vs 1
Format 0 (default) gives concise output. Format 1 wraps text in quotes and preserves special characters — useful for debugging.
Unlike TEXT function
TEXT requires a format string (like "0.00"). VALUETOTEXT needs no format — it just converts the raw value to its literal text representation.
Use for display columns
In mixed-type data, VALUETOTEXT lets you display all values uniformly as text while preserving their original representation.
Try VALUETOTEXT in Viztab
Import your data and use VALUETOTEXT with 370+ other formulas. No signup required.
Open Viztab