The below example lets you understand how to convert binary number to its equivalent decimal. The
Binary to Decimal Conversion have been accomplished by the Excel formula
BIN2DEC(). The binary input should not be more than 10 bits otherwise it returns the #NUM! error value. The most significant bit is sign bit and the remaining 9 bits are magnitude bits
Syntax
BIN2DEC(number)
Binary to Decimal Conversion Example