Formualizer Docs
ReferenceFunctionsText Functions

NUMBERVALUE

NUMBERVALUE: Converts locale-delimited text to a number.

Summary

Parses text using explicit decimal and group separators, independent of the workbook's invariant locale.

Remarks

  • The decimal separator defaults to ..
  • The group separator defaults to ,.
  • Percent suffixes are supported and scale the result by 100 per suffix.

Examples

Parse with explicit separators
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1234.56
Parse percent suffix
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.125

FAQ

Does NUMBERVALUE use the global locale?

No. Decimal and group separators are passed explicitly as arguments.

Runtime metadata

Category

Text

Signature

NUMBERVALUE(arg1…: Any)

This function accepts a repeating argument pattern (min args: 1).

Arity

min 1, max variadic

Arguments

arg1

Any · Scalar

Caps

PURE

Source

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

MIDB

MIDB: Extracts text from the middle using non-DBCS byte-compatible semantics.

PROPER

PROPER: Capitalizes the first letter of each alphanumeric word.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes NUMBERVALUE use the global locale?Runtime metadata