Navigation:  Formulas and functions > Functions from A to Z > BIN2DEC (binary number to decimal number)

Syntax:

BIN2DEC(Number)

Description:

This converts the given binary number (base 2) to a decimal number (base 10).

Number is the number to be converted.

Negative numbers have to be transformed to two's complement notation (see last example).

Number must not contain more than 32 places, thus the permissible value range is:

-(2^31) ≤ Number ≤ (2^31)-1

Example:

BIN2DEC("101010") returns 42

BIN2DEC("00101010") also returns 42

BIN2DEC("11111111111111111111111111010110") returns -42

See also:

DEC2BIN, BIN2HEX, BIN2OCT, DECIMAL