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