Excel Function BIN2DEC

BIN2DEC(number)

Returns the number converted from binary to decimal.

number

The binary number you want to convert.

Remarks

* If "number" contains more than 10 characters (10 bits), then #NUM! is returned.
* If "number" contains 10 characters then the most significant bit (i.e. the first number) represents the sign bit (i.e either positive or negative). See rows 6 and 7.
* If "number" is not a valid binary number, then #NUM! is returned.
* Any negative numbers are represented using two's complement notation.
* You can use the BIN2HEX function to convert a number from binary to hexadecimal.
* You can use the BIN2OCT function to convert a number from binary to octal.
* You can use the DEC2BIN function to convert a number from decimal to binary.
* In Excel 2007 the accuracy of this function was improved.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

	A
1	=BIN2DEC(1) = 1
2	=BIN2DEC(10) = 2
3	=BIN2DEC(100) = 4
4	=BIN2DEC(111) = 7
5	=BIN2DEC(10001) = 17
6	=BIN2DEC(100000000) = 256
7	=BIN2DEC(1100000000) = -256
8	=BIN2DEC(1111111111) = -1
9	=BIN2DEC(1111111110) = -2
10	=BIN2DEC(1111111101) = -3
11	=BIN2DEC(1111110011) = -13
12	=BIN2DEC(1111110000) = -16
13	=BIN2DEC(1000000000) = -512
14	=BIN2DEC(123456789012) = #NUM!
15	=BIN2DEC("some text") = #NUM!