Summary

DEC2BIN converts a decimal number into binary text. If you have a normal base-10 value and want to see its base-2 bit pattern, this is the function to use.

This is useful when the bit pattern matters more than the decimal number itself. It comes up in status flags, masks, fixed-width fields, and any workflow where you need to see exactly which bits are on or off.

Syntax

=DEC2BIN(number, [places])

number is the decimal value to convert. places is optional and pads positive results with leading zeros.

The main value is the converted binary text. If you need a fixed-width result, add places. If you leave it out, Excel uses the shortest binary form it can. Negative values follow the signed 10-bit engineering format instead of normal left-padding.

Arguments

• number - [required] The decimal integer to convert. Excel supports values from -512 to 511.
• [places] - [optional] The minimum number of binary characters to return for positive values.

number has to be a whole number in the supported range. places is only for positive results and is best used when the output needs to match a fixed field such as 8 bits or 10 bits. If the converted value will not fit inside the places value you provide, Excel returns #NUM!.

DEC2BIN vs similar functions

DEC2BIN is the right choice when the output needs to be a visible bit pattern:

Using DEC2BIN

The simplest use is taking a decimal value and showing the bit pattern behind it. That makes it much easier to inspect masks, flags, or fixed-width binary fields than trying to reason from the decimal value alone.

The places argument lets you pad positive results with leading zeros. For example, 15 becomes 1111 by default, but with 8 places it becomes 00001111. If the result needs more characters than the places value allows, Excel returns #NUM!.

Negative values use the signed format built into these engineering functions. Excel returns them as full 10-bit binary strings and ignores places, which is why DEC2BIN(-1) returns 1111111111.

Example 1 - Convert 10 to binary

This is the simplest use of DEC2BIN: take an ordinary decimal integer and expose the bit pattern behind it. Excel returns 1010, which makes it easier to reason about individual bit positions than the decimal value 10 alone.

=DEC2BIN(10) // Returns "1010"

Example 2 - Pad the result to 8 bits

The places argument matters when the output has to match a fixed-width field such as a byte. Without padding, 15 becomes 1111. With 8 places, Excel returns 00001111, which preserves the same value while making the length suitable for register-style or mask-style work.

=DEC2BIN(15, 8) // Returns "00001111"

Example 3 - Convert a negative value

Negative numbers are not padded in the same way as positive ones. Instead, Excel returns a signed 10-bit binary result, so -1 becomes 1111111111. This is useful when the workbook needs to represent signed values in the same fixed-width format used by Excel's engineering conversion functions.

=DEC2BIN(-1) // Returns "1111111111"

Example 4 - Convert 252 to binary

The value 252 becomes 11111100, which is much more informative if you are inspecting a mask or fixed network-style pattern. In decimal, the structure of the value is hidden. In binary, you can immediately see which low-order bits are clear and which higher bits are set.

=DEC2BIN(252, 8) // Returns "11111100"

Quick recap

• Converts decimal to binary: DEC2BIN returns base-2 text from a base-10 number.
• Supports values from -512 to 511: That is the main numeric range for this function.
• Places pads positive values: Use it for fixed-width output.
• Negative values ignore places: Excel returns them as signed 10-bit binary strings.
• Useful when the bits matter: It is helpful for flags, masks, and fixed-width binary displays.