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.

Create a table or use an existing one. Type =DEC2BIN(A2, B2) into the cell you want to place the result. Then press the Enter key to see the result. To see the other results in the table, drag the ...

The binary number will appear. With this example, Excel will display "01100100." The initial zero does not affect the number's magnitude, but it completes the byte.

The binary conversion function has an index of 0 to 18, while the BCD conversion function uses an index of 0 to 20. The decimal range of 0 to 99,999 determines these indices.