Article updated on April 07, 2018

The DEC2BIN function converts a decimal number to a binary number.

Formula in cell D3:

=DEC2BIN(B3,C3)

Excel Function Syntax

DEC2BIN(number, [places])

Arguments

number Required. The decimal integer you want to convert.
[places] Optional. The number of characters to use. If not entered the function uses the number of characters needed to complete the task. This argument allows you to add leading 0s (zeros).