TEXT2NUM

Syntax

TEXT2NUM (Text)

Description

Converts Text to a number. This performs a forgiving conversion. For example, dollar signs and commas are ignored, parentheses or a minus sign make the number negative, and % causes the number to be converted as a percentage. If there is no number in the text, the function returns 0.

Example

These examples employ the TEXT2NUM built-in function:

• TEXT2NUM("TEN") returns 10.

• TEXT2NUM("$TEN") returns 10.

• TEXT2NUM("-TEN") returns -10.

• TEXT2NUM("100,000") returns 100000.

• TEXT2NUM("10%") returns 10%.