BIN2DEC function

Category: Engineering
Introduced: Excel 2003

Summary

Converts a binary number to decimal

Syntax

BIN2DEC(number) The BIN2DEC function syntax has the following arguments:
• Number Required. The binary number you want to convert. Number cannot contain more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation.

Example

=BIN2DEC(1100100)
=BIN2DEC(1111111111)

Microsoft Support Page

https://support.microsoft.com/en-us/office/bin2dec-function-63905b57-b3a0-453d-99f4-647bb519cd6c

Back to Functions