Using the Excel BIN2DEC Function
SummaryThe Excel BIN2DEC function converts a binary number to a decimal. Inputs must contain only 0 (zero) and 1, and must be less than 10 characters, otherwise the function will return the #NUM! error.
Required. The number, in binary format, that you wish to convert to a decimal. Negative numbers are represented using two's-complement notation. Number must be less than 10 characters (10 bits).
Usage NotesBIN2DEC converts a number from binary to its decimal equivalent. The first bit indicates if the number is negative or positive. The remaining 9 digits represent the actual number.
The function will return an error in the following instances:
1) The binary input is an invalid binary number
2) The number argument is greater than 10 characters (10 bits)