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)FormulaThe 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)FormulaThe strict text representation is:
"Order 00731"ExampleThe 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)FormulaThe 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.