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.

You will see Hex (Hexadecimal), Dec (Decimal), Oct (Octal) and Bin (Binary) radio buttons. These are used for converting numbers between these numbering systems. Ensure that Dec (Decimal) radio ...

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.