Related Function:

The BIN2DEC function converts a binary number to decimal.



Note: Hexadecimal (base 16), decimal (base 10), octal (base 8), and binary (base 2) are the most commonly used numeral systems in engineering and computing. Therefore, Excel has provided functions to convert numeric values to and from each of these systems.


Argument Description
number The binary number you want to convert

  The number cannot contain more than 10 characters (10 bits)
  The most significant bit of number is the sign bit
  The remaining 9 bits are magnitude bits
  Negative numbers are represented using two’s-complement notation


  A B C
1 Formula Result Notes
2 =BIN2DEC(1100100) 100 Converts binary 1100100 to decimal
3 =BIN2DEC(1111111111) -1 Converts binary 1111111111 to decimal

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the supplied number argument is not recognized as a binary number, or contains more than 10 characters
#NAME? Occurs when Analysis ToolPak add-in is not enabled

The Binary (Base 2) Numeral System uses the digits 0 & 1.

The following table shows the first 8 binary values, along with the equivalent decimal values:

Binary 1 10 11 100 101 110 111 1000
Decimal 1 2 3 4 5 6 7 8

For further information on the binary numeral system, see the Wikipedia Binary Page