Returns a text representation of a number, in a specified base radix.


BASE(number, radix, minlength)

converts number (a positive integer) to text, with the base radix radix (an integer between 2 and 36), using characters 0-9 and A-Z.
minlength (optional) specifies the minimum number of characters returned; zeroes are added on the left if necessary.


BASE(17, 2)
returns 10001 as text (binary system).
BASE(17, 10)
returns 17 as text (decimal system).
BASE(255, 16, 4)
returns 00FF as text (hexadecimal system). Extra zeroes are added to give 4 characters.
ISTEXT(BASE(17, 10))
returns TRUE. Text is returned, not a number.

Created with Zapof