Show All

Hide All

Converts a binary number to decimal.

If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.

Syntax

BIN2DEC(number)

Number    is the binary number you want to convert. 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.

Remark

If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2DEC returns the #NUM! error value.

Example

The example may be easier to understand if you copy it to a blank worksheet.