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.

Create a table with headings Binary and Hex, or use an existing one. Under the hex heading type =BIN2HEX(A2,5). A2 is the Binary number you want to convert.

Binary and hexadecimal are a bit baffling at a glance. The idea that a computer uses numbers and letters as representations of other numbers isn’t exactly the easiest idea to wrap your head ...