This article describes the formula syntax and usage of the BIN2DEC function in Microsoft Excel.

This function converts a binary number to decimal.

Negative numbers are represented using two's-complement notation.

Syntax

=BIN2DEC(BinaryNumber)

The binary number has a limit of ten characters.