Formualizer Docs
ReferenceFunctionsText Functions

VALUE

Converts text that represents a number into a numeric value.

Summary

Converts text that represents a number into a numeric value.

Remarks

  • Parsing uses locale-aware invariant number parsing from the function context.
  • Non-numeric text returns #VALUE!.
  • Booleans and numbers are first coerced to text, then parsed.
  • Errors are propagated unchanged.

Examples

Parse decimal text
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
12.5
Invalid numeric text
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#VALUE!

FAQ

Does VALUE coerce arbitrary text like TRUE/FALSE?

VALUE parses numeric text only; non-numeric strings return #VALUE!.

Runtime metadata

Category

Text

Signature

VALUE(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

UPPER

Converts text to uppercase.

VALUETOTEXT

VALUETOTEXT: Converts a value to text representation.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes VALUE coerce arbitrary text like TRUE/FALSE?Runtime metadata