The Excel BASE function converts a number to the text representation of the given radix (base).
Convert number to another base.
The text representation of the converted number.
=BASE (number, radix, [min_length])
number - The number you want to convert to another representation.
radix - The base of the representation being converted to.
min_length - [optional] Guarantees the minimum length of the returned string by padding the string with zeros.
The Excel BASE function returns the text representation of a number converted to another base. In the worksheet shown, the input numbers are being converted to three different representations: base 2 (binary), base 10 (decimal), and base 16 (hexadecimal). The radix value specifies the base representation of the returned text. For example, to convert the number 3 into its binary representation (base 2) the formula would be:
=BASE(3,2)// Returns "11" as text, 3 in binary (base 2)
=BASE(10,16)// Returns "A" as text, 10 in Hexadecimal (base 16)
The function also offers an optional argument min_length which will pad the returned string with zeros if is length is less than the provided value.
=BASE(3,2,4)// Returns "0011" as text=BASE(10,16,4)// Returns "000A" as text