Calc NUMERIZE function

For a full list of available calculation functions, please read What calculation functions are supported.

Description

The NUMERIZE function converts a written number i.e. "one hundred and twenty three" into a numeric value i.e. 123. It can handle both whole numbers and decimal numbers.

Syntax

NUMERIZE(text)

The NUMERIZE function syntax has the following arguments:

• text: Required. The text string representing the written number you want to convert to a numeric value.

Remarks

• The function can handle numbers up to the billions.
• The function ignores case and extra spaces.
• The function can handle both whole numbers and decimal numbers. For decimal numbers, use the word "point" to separate the whole number from the decimal part. For example, "one hundred and twenty three point four five" will be converted to 123.45.
• If the text does not represent a valid written number, the function returns an error.

Example

Errors

For a full list of formula errors, please read Formula errors.

Related functions

• Calc BIN2DEC function
• Calc BIN2HEX function
• Calc BIN2OCT function
• Calc CONVERT function
• Calc DEC2BIN function