DEC2BIN Function

You can convert Decimal numbers into binary numbers
The binary numbers contain only 0 and 1 values


DEC2BIN Function has a limit of 511 Decimal numbers
If you write more than 511 characters it will return #NUM error

Syntax

=DEC2BIN(number,[places])

Argument

Number: it is the number you want to convert into binary
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.

Behavior

Here we have taken an example of the decimal number and convert it into binary numbers.
We have written a formula  

=DEC2BIN(D4,9) which will convert the decimal number into binary and show result till 9 characters. No character place is fill by 0

On the right side, if you write 511 it will return 9 times "1"
If you write 512 it will return #NUM error

Usage

To convert a Decimal number into a Binary number

Returns

Binary number