In hex, numbers between zero and nine are represented as they are in decimal, with number ten using the letter A, then 11 as B and so on up to F, which is 15. The 12 is therefore C in hexadecimal.

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.

Example - convert decimal 22 to hexadecimal. 16 goes into 22 once with 6 left over, so 22 ÷ 16 = 1 remainder 6. 1 = hex 1. 6 = hex 6. Result - 16. Example - convert 138 to hexadecimal.

To use the BIN2HEX function to convert a binary or decimal to hexadecimal in Excel, follow the steps below: Launch Excel Create a table or use an existing table Type the formula BIN2HEX into the ...