Learn Excel - Simplify Life with Excel Concepts

Excel BIN2DEC Function

BIN2DEC Function Example

How to use the BIN2DEC Function

This Excel tutorial explains how to use the Excel BIN2DEC function with syntax and examples.


The Excel BIN2DEC function converts a binary number to a decimal number. The input number must contain only zeros and ones and be less than 10 characters long, otherwise the function returns the #NUM! error value.

For example,

  • The formula =BIN2DEC(101) would return 5
  • The formula =BIN2DEC(10) would return 2


To converts a binary number to decimal.


The BIN2DEC function returns a Decimal Number.




The BIN2DEC function syntax has the following arguments:

  • number: Required. The binary number you want to convert to a decimal.
    • 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.
  • If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2DEC returns the #NUM! error value.

Useful Links: Link 1Link 2Link 3Link 4