DEC2BIN(number, Number_of_characters_to_use) converts a decimal number to binary : DEC2BIN « Engineering functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Engineering functions
  3. DEC2BIN

If number < -512 or if number > 511, DEC2BIN returns the #NUM! error value.

Input the formula: =DEC2BIN(-100). Press Enter to get the result
Input the formula: =DEC2BIN(-100)
16.10.DEC2BIN
16.10.1.DEC2BIN(number, Number_of_characters_to_use) converts a decimal number to binaryDEC2BIN(number, Number_of_characters_to_use) converts a decimal number to binary
16.10.2.=DEC2BIN(9, 4) converts decimal 9 to binary with 4 characters=DEC2BIN(9, 4) converts decimal 9 to binary with 4 characters