Article updated on March 28, 2018

The BIN2DEC function converts a binary number to decimal.

Formula in cell B3:


Excel Function Syntax



number Required. The binary number you want to convert.


Maximum binary values are 10 characters.

Number cannot contain more than 10 characters (10 bits).

To convert a decimal value to binary use the DEC2BIN function.

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, […]