DEC2BIN

Converts the specified decimal number to its binary equivalent.

Syntax

DEC2BIN( NumberOrText x, [Integer digits] ) → Text

Parameters

x

Required. The decimal number to convert, expressed as either text or number.

digits

Optional. The number of characters to use for the result, useful for padding the return value with leading zeros.

Remarks

If x is less than -512 or greater than 511, the function returns the #NUM! error value. If x is non-numeric, the function returns the #VALUE! error value.

If digits is omitted, the function uses the minimum number of characters necessary. If digits is specified and is less than the number of characters required to represent the result, the function returns the #NUM! error value. If digits is negative or greater than 10, the return value is #NUM!. If digits is not an integer number, it is truncated.

Example

Formula

=DEC2BIN(11,4)
=DEC2BIN(-10)

See Also

Function Reference
BIN2DEC Function
HEX2DEC Function
OCT2DEC Function