Text

VALUETOTEXT Function in Excel

Returns text from any specified value.

Syntax

  • =VALUETOTEXT(value, [format])

Arguments

  • value (required): Value to convert
  • format (optional): 0=concise, 1=strict

Examples

  • =VALUETOTEXT(A1) - Convert value to text - Result: Text representation

Excel VALUETOTEXT function documentation

  • VALUETOTEXT returns text that represents a value — preserves what you see for export.
  • Syntax: =VALUETOTEXT(value, [format]). Microsoft 365 function.
  • Use when concatenating numbers without losing display formatting context.
  • Related: [TEXT](/functions/text/), [FORMULATEXT](/functions/formulatext/), [ARRAYTOTEXT](/functions/arraytotext/).

VALUETOTEXT syntax and format flag

  • value: number, date, or logical to convert.
  • format 0 (default): concise text; 1: strict/locale-preserving format.
  • Differs from TEXT — VALUETOTEXT aligns with value-as-display rules in 365.
  • Spill arrays: applies element-wise in dynamic contexts.

Step-by-step: build export string from mixed column

  • Step 1 — Mixed values dates and numbers in column A.
  • Step 2 — =VALUETOTEXT(A2) for CSV-safe text representation.
  • Step 3 — Concatenate: =VALUETOTEXT(B2)&" - "&VALUETOTEXT(C2).
  • Step 4 — Compare with TEXT for date format control.
  • Step 5 — Audit exports before sending to external systems.

VALUETOTEXT vs TEXT vs CONCAT

  • VALUETOTEXT — value fidelity for 365 interoperability.
  • TEXT — custom format codes.
  • CONCAT/ & — may coerce numbers differently.
  • Information/text crossover for modern workbooks.

Worked examples to copy

  • Basic: =VALUETOTEXT(A2).
  • Strict: =VALUETOTEXT(A2, 1).
  • In label: ="Total: "&VALUETOTEXT(total_cell).
  • Array row: =VALUETOTEXT(spill_cell).

People also ask

  • VALUETOTEXT Excel 2019? — No; Microsoft 365.
  • VALUETOTEXT vs TEXT for dates? — TEXT gives explicit format code control.
  • VALUETOTEXT locale? — format 1 respects locale display.
  • VALUETOTEXT in LAMBDA? — Yes as scalar function.

Common errors

  • Requires Excel 365

Use cases

  • Value display
  • Debugging
  • Data export

Frequently asked questions

  • What is VALUETOTEXT used for? VALUETOTEXT converts any value to text, preserving its display format. Unlike TEXT which requires a format code, VALUETOTEXT automatically converts values to their text representation. Great for debugging and creating text versions of data.
  • What's the difference between format 0 and 1? Format 0 (concise): shows value as displayed, like '1234.56'. Format 1 (strict): shows value in a format that could be re-entered as a formula, like '"text"' for strings or dates as serial numbers. Use strict for formula debugging.
  • When should I use VALUETOTEXT vs TEXT? Use TEXT when you need specific formatting: =TEXT(date, "MM/DD/YYYY"). Use VALUETOTEXT when you just want the value as text without specifying format. VALUETOTEXT is simpler; TEXT gives more control.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.

When to use VALUETOTEXT

  • Value display — common Text scenario for VALUETOTEXT.
  • Debugging — common Text scenario for VALUETOTEXT.
  • Data export — common Text scenario for VALUETOTEXT.

VALUETOTEXT in the Text category

  • Browse all Text functions at /categories/text/ for related formulas.
  • VALUETOTEXT syntax: =VALUETOTEXT(value, [format])
  • value (required): Value to convert
  • format (optional): 0=concise, 1=strict
  • Confirm VALUETOTEXT arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.

Formula checklist before you copy down

  • Confirm VALUETOTEXT arguments match the syntax shown above before filling down.
  • Lock table and range references with $ when copying formulas across rows or sheets.
  • If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
  • Spot-check three known input rows manually against expected output.

Related Excel functions

  • ARRAYTOTEXT (/functions/arraytotext/): Returns an array of text values from any specified range.
  • TEXT (/functions/text-function/): Converts a value to text in a specified number format.
  • T (/functions/t/): Returns the text referred to by value.

Errors to watch for

  • Requires Excel 365 — review causes on linked error pages in the directory.

Copy-paste audit workflow

  • Enter VALUETOTEXT on three test rows with known expected output documented on a QA tab.
  • Fill down only after absolute references are locked on lookup tables and rate tables.
  • Compare against manual calculation or a calculator for financial and statistical functions.
  • Search this directory for comparison guides when choosing between similar functions in the same category.

VALUETOTEXT worked examples to copy

  • =VALUETOTEXT(A1) — Convert value to text. Expected result: Text representation.

VALUETOTEXT reference summary for crawlers and offline review

  • VALUETOTEXT belongs to the Text category in Excel. Returns text from any specified value.
  • Full syntax: =VALUETOTEXT(value, [format]). Open /functions/valuetotext/ for parameters, FAQs, and related pages.
  • Common mistakes: Requires Excel 365
  • Pair this function with comparison guides when another Excel formula might fit the same task better.
  • Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.