Excel like a finance pro.
← The libraryPractice · 2 questions →
Text function
VALUETOTEXT
Returns any value as text.
Rarely usedDifficulty 1200 · ProficientUsage rank #271 of 520
When to use it
Turns a single value into text, with concise or strict formatting. Strict wraps text in quotes.
The shape of it
- Syntax
=VALUETOTEXT(value, [format])
Worked examples
Number
=VALUETOTEXT(123) → 123
A number as text.
Strict text
=VALUETOTEXT("abc",1) → "abc"
Strict mode adds quotes to text.
Logical
=VALUETOTEXT(TRUE) → TRUE
Logicals become their words.
Worth knowing
- Useful for building messages that show what type a value was.
- ARRAYTOTEXT is the array version.
- Dates become their serial numbers; use TEXT for formatted dates.
Where it goes wrong
- Errors are returned as their text rather than propagating.
- Requires Excel 2021 or Microsoft 365.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.