To use the BIN2HEX function to convert a binary or decimal to hexadecimal in Excel, ... Method two is to click the Formulas tab and click the More Functions button in the Function Library group.

Let's take the example further, and convert each hexadecimal digit to its decimal equivalent and then add them: (16 2 x 1) + (16 0 x 15) + (16 0 x 4) = (256 + 240 + 4) = 500. Hex and binary in action.

Learn about digital data and how computers understand it, including binary, denary, hexadecimal numbers, units of data, character sets and logic gates.