Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Engineering Functions

 

BIN2HEX(number, number_of_characters_to_use) converts a binary number to hexadecimal

The most significant bit is the sign bit. The remaining bits are magnitude bits. Negative numbers are represented using two's-complement notation. Input the formula: =BIN2HEX(1110) Press Enter to get the result