DEC2BIN

Converts a decimal number to binary.

Syntax

=DEC2BIN(Number, [Places])

Arguments

Name	Description
Number	The decimal number to convert.
Places (optional)	The number of characters to use for returned value. If value has less characters then it is padded with leading zeros.

Return

The binary number or a #NUM! error if given number is not a valid decimal number. The #VALUE! error is returned if specified places is not numeric or negative.

Examples

Formula	Result	Comment
=DEC2BIN(9)	1001	converts decimal 9 to binary
=DEC2BIN(9, 6)	001001	converts decimal 9 to binary with 6 characters