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

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

  1. A number as text

    ABC
    1Value
    21234.51234.5

    In C2: =VALUETOTEXT(A2) → 1234.5

    Try this example

  2. Text in quotes, to spot spaces

    ABC
    1Value
    2Ana "Ana "

    In C2: =VALUETOTEXT(A2, 1) → "Ana "

    Try this example

Common mistakes

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.

Translate a whole formula

Try VALUETOTEXT in the playground

Related functions