Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Engineering Functions

 

DEC2BIN(number, Number_of_characters_to_use) converts a decimal number to binary

If number 511, DEC2BIN returns the #NUM! error value. Input the formula: =DEC2BIN(-100). Press Enter to get the result