How to use the Excel CBC2BIN formula | CBC2BIN formula How to use it

	Decimal Number	Binary Equivalent
	0	0	=DEC2BIN(C4)
	1	1	=DEC2BIN(C5)
	2	10	=DEC2BIN(C6)
	3	11	=DEC2BIN(C7)
	511	111111111	=DEC2BIN(C8)
	512	#NUM!	=DEC2BIN(C9)
	-1	1111111111	=DEC2BIN(C10)
	-2	1111111110	=DEC2BIN(C11)
	-3	1111111101	=DEC2BIN(C12)
	-511	1000000001	=DEC2BIN(C13)
	-512	1000000000	=DEC2BIN(C14)
	Decimal Number	Places To Pad	Binary Equivalent
	1	1	1	=DEC2BIN(C17,D17)
	1	2	01	=DEC2BIN(C18,D18)
	1	3	001	=DEC2BIN(C19,D19)
	1	9	000000001	=DEC2BIN(C20,D20)
	-1	1	1111111111	=DEC2BIN(C21,D21)
What Does It Do ?
This function converts a decimal number to its binary equivalent.
It can only cope with decimals ranging from -512 to 511.
The result can be padded with leading 0 zeros, although this is ignored for negatives.
Syntax
=DEC2BIN(DecimalNumber,PlacesToPad)
The PlacesToPad is optional.
Formatting
No special formatting is needed.