Excel functions / Text
VALUETOTEXT function
Any value as text. Text passes through unchanged, or in quotes in the strict format.
Syntax
=VALUETOTEXT(value, [format])
Arguments
value: The value.format(optional): 0 (default): as it reads. 1: text in quotes, as typed in a formula.
When to use it
VALUETOTEXT turns any value into text: numbers, dates (as their serial number), TRUE and FALSE, and errors. With 1 as the second argument, text comes back in quotes, which helps to see spare spaces.
Examples
A number as text
A B C 1 Value 2 1234.5 1234.5 In C2:
=VALUETOTEXT(A2)→ 1234.5Text in quotes, to spot spaces
A B C 1 Value 2 Ana "Ana " In C2:
=VALUETOTEXT(A2, 1)→ "Ana "
Common mistakes
- Wanting a formatted number. VALUETOTEXT ignores number formats. For "$1,234.50", use TEXT with a format.
VALUETOTEXT in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Danish: VÆRDITILTEKST
- Finnish: ARVO.TEKSTIKSI
- French: VALEUR.EN.TEXTE
- German: WERTZUTEXT
- Hungarian: ÉRTÉK.SZÖVEGGÉ
- Italian: VALORE.A.TESTO
- Norwegian: VERDITILTEKST
- Polish: WARTOŚĆ.NA.TEKST
- Russian: ЗНАЧЕНИЕВТЕКСТ
- Spanish: VALORATEXTO
- Swedish: VÄRDETILLTEXT
- Turkish: DEĞERMETİN
Try VALUETOTEXT in the playground
Related functions
- ARRAYTOTEXT: All the values of a range written out as one piece of text.
- TEXT: Formats a number as text using a format code.
- T: Returns the value if it is text, otherwise empty text.