Author: Oscar Cronquist Article last updated on May 11, 2022

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