ID EN
#Engineering

DEC2BIN

Excel Functions

Converts a decimal number to binary

Syntax

EXCEL
=DEC2BIN(number, [places])

Arguments

Parameter Description
number The decimal number you want to convert to binary.
places [optional] Pads the resulting binary number with zeros up to the specified number of digits. If omitted returns the least number of characters required to represent the number.

Return Value

Binary number

Details

The input must be a valid number within the range [ -512, 511 ].

See Also

BIN2DEC