Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
VALUETOTEXT
VALUETOTEXT converts a cell value of any type — number, date, logical, error, or text — into its text representation. Concise mode (0) returns a human-readable string, while strict mode (1) formats the value as it would appear inside an array formula literal, which is useful for dynamic formula construction.
Excel
=TEXT(A2,"General")Google Sheets
=VALUETOTEXT(A2,0)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Reference the cell whose value you want as text (e.g., A2 containing the number 1234 or a date).
- 2Enter =VALUETOTEXT(A2,0) to get a plain-text version — numbers appear without formatting, dates as their serial number text.
- 3Switch to mode 1 with =VALUETOTEXT(A2,1) to get a quoted or typed representation suitable for embedding in formula strings.
Need a version for your data?
Try: “Convert a mix of numbers and dates in a column to plain text strings for concatenation”