BIN2DEC Function in Excel – Convert Binary to Decimal in Excel

BIN2DEC Function in Excel converts Binary number to a decimal number.

Syntax of BIN2DEC Function in Excel (BINARY TO DECIMAL FUNCTION IN EXCEL):

BIN2DEC(number)

Where the number argument is the binary number that is to be converted to a decimal.

 

Example of BIN2DEC Function in Excel (BINARY TO DECIMAL FUNCTION IN EXCEL):

Formula:

BIN2DEC Function in Excel 1

  • The supplied binary value should not have more than 10 character

Result:

BIN2DEC Function in Excel 2

Note:

#NUM! – Error occurs if the supplied number argument is not recognized as a binary number, or contains more than 10 characters.

previous BIN2DEC Function in Excel                                                                                                           next BIN2DEC Function in Excel

Do NOT follow this link or you will be banned from the site!