The DEC2BIN function in Microsoft Excel is an Engineering function, and its purpose is to convert a decimal number to binary. The formula for the DEC2BIN is DEC2BIN( Number, [Places]).

Warnings Excel will only produce binary numbers with up to 10 bits. This means that it can only convert decimal numbers greater than -513 and less than 512.

The purpose of the Bin2Hex engineering function in Excel is to convert a binary or decimal to hexadecimal. Learn how to use it properly.

Conversion of binary to decimal numbers is often needed in firmware. And it’s done easily enough if multiplication and division by ten are acceptable.