DEC2BIN function

DEC2BIN converts a decimal number to a binary number.

Syntax

DEC2BIN(number, [places])

Number is a decimal number. If Number is negative, the function returns a binary number with 10 characters. The most significant bit is the sign bit, the other 9 bits return the value.

Places means the number of places to be output.

Example

=DEC2BIN(100,8) returns 01100100.