Author: Oscar Cronquist Article last updated on April 07, 2018

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

Formula in cell D3:


Excel Function Syntax

DEC2BIN(number, [places])


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).