# 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). (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.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.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!