Back to functions
Text2026-11-110 related articles

VALUETOTEXT Function in Excel

Convert a value to concise text or a strict text representation with explicit quotation marks.

Syntax

VALUETOTEXT(value, [format])
Table of Contents

Arguments

value

Required

The value or cell reference to convert to text.

format

Optional

Use 0 or omit for concise text; use 1 for a strict representation. Other values return an error.

What it returns

Returns a text representation of the supplied value in the selected format.

What VALUETOTEXT does

VALUETOTEXT turns a value into text. Its default concise format is easy to read; strict format includes quotation marks around text values so the representation distinguishes text from numbers and logical values.

Use it when you need a text representation of the underlying value. If you want to choose a date, currency, or decimal display, use TEXT with a format code instead. For an entire array, see ARRAYTOTEXT.

Practical examples

Keep a text identifier readable

Put the text Order 00731 in A2:

=VALUETOTEXT(A2)
Formula

The result is Order 00731, unchanged as text. Omitting the second argument uses concise format 0. This doesn't extract or convert the digits inside the identifier.

Include the quotation marks in strict format

Using the same A2, enter:

=VALUETOTEXT(A2,1)
Formula

The strict text representation is:

"Order 00731"
Example

The opening and closing double quotation marks are part of the returned text. This result and the concise example were verified in Excel for Mac 16.114 (build 16.114.26101123) on November 11, 2026. In strict format, text is quoted; numbers, logical values, and error tokens are represented without these surrounding quotes. Microsoft's VALUETOTEXT documentation describes these formatting rules.

Convert a value displayed as currency

Put the number 1250.5 in A3 and apply a currency format showing $1,250.50 in US Excel:

=VALUETOTEXT(A3)
Formula

The observed concise result was the text 1250.5 with US-style number settings. The currency symbol, grouping comma, and display-only trailing zero aren't part of the underlying number. Use TEXT if those are the details you want in the output.

Common mistakes and notes

Format accepts only 0 or 1

=VALUETOTEXT(A2,2) returns a real #VALUE! error. The format argument isn't a custom number-format string.

An error token can become text

If A4 contains =NA(), then =VALUETOTEXT(A4) returns the text #N/A. In the same native test, ISTEXT on that result was TRUE and ISERROR was FALSE. The source cell still contains an error; the converted result only looks like one. This differs from an invalid format argument, which makes VALUETOTEXT itself return an error.

Quotation marks change the returned text

Strict output for a text value includes visible quotes. That can matter when comparing it with the original cell or passing it to another formula. Choose concise format when you need the original text without those added characters.

Check the documented editions

The Microsoft Support page reviewed on November 11, 2026 lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, and Excel 2021 for Mac. It doesn't list the Excel 2024 editions, so that page alone doesn't establish their availability.

Related functions

Official documentation