VALUETOTEXT

Excel Functions

Converts a value to a text string

Syntax

EXCEL

=VALUETOTEXT(value, [format])

Arguments

Parameter	Description
`value`	The value to convert to text.
`format`	[optional] Output format. 0 = concise (default), and 1 = strict.

Return Value

Value as a text string

Details

The VALUETOTEXT function converts a value to a text string. By default, text values pass through unaffected. However, in strict mode, text values are enclosed in double quotes (""). VALUETOTEXT will always remove number formatting applied to numeric values, regardless of format. The VALUETOTEXT function takes two arguments: value and format. Value is the value to convert to text. The format argument controls the structure of the output. By default, format is zero and VALUETOTEXT will output a "concise" format text value, essentially the normal format that Excel will use to display any text value. When format is set to 1 (strict format), text values will be enclosed in double quotes (""). With the value 100 in cell A1: In all cases, 100 is returned as a normal text string, and you will not

Examples

With numeric values

With the value 100 in cell A1:

EXCEL

=VALUETOTEXT(A1) // returns "100"
=VALUETOTEXT(A1,0) // returns "100"
=VALUETOTEXT(A1,1) // returns "100"

With text values

With the text "apple" in cell A1:

EXCEL

=VALUETOTEXT(A1) // returns "apple"
=VALUETOTEXT(A1,0) // returns "apple"
=VALUETOTEXT(A1,1) // returns ""apple""

VALUETOTEXT

Syntax

Arguments

Return Value

Details

Examples

See Also