DEC2BIN Function

The DEC2BIN function is used to convert a decimal number to a binary number.


==DEC2BIN(Number, Places)
Whereas Number is the decimal number to be converted and Places is the number of characters to use. The "Number" should not be more than 10 digits. The first bit is sign bit and the remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation.
Note: If number < -512 or if number > 511, DEC2BIN returns the #NUM! error value.

Video Tutorial:

Let us convert a decimal number to a binary number, using the DEC2BIN function, with the help of the below video.

Learn MS Excel

Ask Questions

Ask Question