Author: Oscar Cronquist Article last updated on March 28, 2018

The BIN2DEC function converts a binary number to decimal.

Formula in cell B3:

=BIN2DEC(11001)

Excel Function Syntax

BIN2DEC(number)

Arguments

number Required. The binary number you want to convert.

Comments

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