FROMBASETEN

You can use FROMBASETEN when you need to convert numbers to a base other than 10.

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

Syntax:
FROMBASETEN (single-integer-expression, single-integer-expression)
Meaning:
FROMBASETEN (positive_integer_to_convert, base_to_convert_to)
Returns:
A single text item

FROMBASETEN returns a text item that results from converting positive_integer_to_convert to a text item that can be interpreted as a number using positional notation of the base specified by base_to_convert_to.

If base_to_convert_to is less than 2 or greater than 36, FROMBASETEN evaluates to "none". Resulting text item characters A-Z are interpreted as digits having decimal values from 10-35, respectively. The characters returned are uppercase.

Example

  • FROMBASETEN (18, 2)

    Returns the value 10010

  • FROMBASETEN (123, 8)

    Returns the value 173

Related function

  • TOBASETEN

Feedback