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.