Article updated on March 28, 2018

The BASE function converts a number into a text representation with a given radix (base).

Formula in cell C3:

=BASE(10, 16)

Excel Function Syntax

BASE(number, radix, [min_length])

Arguments

number Required. The number that you want to convert. Must be an integer greater than or equal to 0 (zero) and less than 2^53.
radix Required. The base of the number you want it to convert into. 2 <= radix <= 36.
[min_length] Optional. The minimum length of the returned string. [min_length] must be an integer greater than or eual to 0 (zero).

Comments

Use the min_length argument to add leading zeros to the resulting value. BASE(16,2) returns 10000, however, BASE(16,2,8) returns 00010000.

The DC2BIN function also allows you to convert numbers into binary values.

How to use the DEC2BIN function

The DEC2BIN function converts a decimal number to a binary number. Formula in cell D3: =DEC2BIN(B3,C3) Excel Function Syntax DEC2BIN(number, […]

The DECIMAL function converts a text representation of a number in a given base into a decimal number.

How to use the DECIMAL function

The DECIMAL function converts a text representation of a number in a given base into a decimal number. Formula in […]