The DEC2BIN function converts a decimal number into a binary number. It is useful for converting decimal numbers to binary format for various applications.


=DEC2BIN(Number, [Places])

Number The decimal number you want to convert to binary.
Places (Optional) The number of characters to use. Defaults to 10 if omitted.


DEC2BIN in Excel assists you in effortlessly transforming decimal numbers into their binary equivalents. This function proves invaluable for tasks that involve converting numerical data into binary representations, such as in computer programming and digital communication protocols. It simplifies the process by automatically converting decimal values to binary format, saving you time and effort in manual conversions. By inputting a decimal number, you can swiftly obtain the corresponding binary output with precision and accuracy. DEC2BIN streamlines the conversion process, facilitating seamless integration of binary calculations into your spreadsheets for enhanced functionality and data manipulation.


If you have the decimal number 15 and want to convert it into binary with a length of 8 digits, the formula would be =DEC2BIN(15, 8). This will yield the binary representation of 15 as '00001111'.

For a larger decimal number like 1000 and you wish to represent it in binary using 12 digits, you can use the formula =DEC2BIN(1000, 12). The result will display the binary equivalent of 1000 as '0000001111101000'.


How does the DEC2BIN function handle decimal numbers with decimals?

The DEC2BIN function only works with whole numbers or integers. If you provide a decimal number as input, it will be truncated to the nearest lower integer before converting to binary.

Can the DEC2BIN function handle negative decimal numbers?

No, the DEC2BIN function is designed to convert positive decimal numbers into binary format. It does not support the conversion of negative decimal numbers.

What happens if the Places argument in DEC2BIN is smaller than the binary representation of the converted number?

If the Places argument is smaller than the actual length of the binary representation of the converted number, Excel will display a series of pound sign (#) errors to indicate that the binary output exceeds the specified Places value. To avoid this, ensure the Places argument is equal to or greater than the required length of the binary output.

Is there a limitation on the size of decimal numbers that the DEC2BIN function can handle?

Although Excel does not impose a specific limit on the size of decimal numbers for DEC2BIN, it is recommended to verify the output for very large decimal numbers to ensure accurate conversion and representation in binary format.

Related functions