TOBASETEN

The TOBASETEN function converts a text item that can be interpreted as a number, using positional notation of the base specified, to a base 10 number.

Syntax:
TOBASETEN ( single-text-expression, single-integer-expression )
Meaning:
TOBASETEN ( text_to_convert, base_to_convert_from )
Returns:
A single integer

TOBASETEN returns a number that results from converting text_to_convert that can be interpreted as a number, using positional notation of the base specified by base_to_convert_from, to its base 10 representation. Text item characters A-Z are interpreted as digits having decimal values from 10-35, respectively.

If base_to_convert_from is less than 2 or greater than 36, TOBASETEN evaluates to "none". If text_to_convert contains a character that is not alphanumeric or is not in the range specified by base_to_convert_from, TOBASETEN returns "none".

Examples

  • TOBASETEN ( "A", 16 )

    Returns the value 10

  • TOBASETEN ( "10", 36 )

    Returns the value 36

  • TOBASETEN ( "A0", 15 )

    Returns the value 150

  • TOBASETEN ( "A0", 5 )

    Returns the value "none"

Related functions

  • FROMBASETEN