Formualizer Docs
ReferenceFunctionsText Functions

VALUETOTEXT

VALUETOTEXT: Converts a value to text representation.

Summary

VALUETOTEXT(value, [format]) supports concise (0) and strict (1) modes.

Remarks

  • Concise mode (0) returns natural text for scalars.
  • Strict mode (1) adds explicit quoting for text and serializes arrays with braces.
  • In concise mode, error values are propagated as errors.
  • In strict mode, error values are rendered as their error text.

Examples

Concise text conversion
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
123
Strict quoting for text
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
"hello"

FAQ

How are errors handled in concise vs strict mode?

Concise mode returns the error, while strict mode converts the error to its text form.

Runtime metadata

Category

Text

Signature

VALUETOTEXT(arg1: Any, arg2?: Number)

Arity

min 1, max 2

Arguments

arg1

Any · Scalar

arg2optionaldefault

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/text/array_text.rs

VALUE

Converts text that represents a number into a numeric value.

Playground

Interactive sandbox docs for trying formulas, parser output, and grid behavior.

On this page

SummaryRemarksExamplesRelated functionsFAQHow are errors handled in concise vs strict mode?Runtime metadata