Related Function:
The BIN2DEC function converts a binary number to decimal.
Syntax
=>BIN2DEC(number)
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.
Arguments
Argument  Description  

number  The binary number you want to convert

Examples
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 addin 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