value

Convert a text string to a number.

Syntax

v = value(text)

Description

Parses text as a numeric value. Recognizes integers, decimals, scientific notation, percentages, currency symbols, and date/time strings (returning the serial number form). Raises #VALUE! on unparseable input.

Examples

value('3.14')           % 3.14
value('$1,234.56')      % 1234.56

See also

• numbervalue — Locale-aware numeric parse.
• text — Format a number as text using an Excel-style format.