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.

How to format with 1 decimal whenever number between -10 and 10, but no decimal when greater than 10 or lesser than -10. For example 9.9 we show one decimal, but 10 comes rounded with no decimal.

I recently needed to convert decimal numbers into base 36 in an Excel for Mac 2011 spreadsheet. Now Windows Excel has the Radix function, which converts base 10 numbers into any base between 2 and ...