# TEXTTONUMBER

Use TEXTTONUMBER to convert text to a number.

The TONUMBER function provides greater flexibility for specifying the format of the text item that is to be converted to a number.

- Syntax:
- TEXTTONUMBER ( single-text-expression )
- Meaning:
- TEXTTONUMBER ( text_to_convert_to_number )
- Returns:
- A single character number

The `text_to_convert_to_number` must
be in integer or ANSI-formatted (floating point) presentation. The resulting
number looks like the input argument, however, nonsignificant zeroes to the
right of the decimal separator will be truncated. If the input argument is
in error (for example, it is not a recognizable as a valid number), the result
is "none".

When specified as in ANSI-formatted presentation, the text string must meet the following requirements:

- The decimal point can be a period, a comma, or "none".
- The leading sign can be a plus sign, a minus sign, or "none".
- No thousands separator is allowed.

## Examples

- TEXTTONUMBER (OrderQty)
Returns

**OrderQty**as a character number item

## Related functions

- DATETOTEXT
- FROMNUMBER
- NUMBERTOTEXT
- TEXTTODATE
- TEXTTOTIME
- TIMETOTEXT