Ensure that Dec (Decimal) radio button is selected. Now type your decimal number. Next, select the Bin (Binary) radio button. This will convert the digit from Decimal to Binary.

Warnings Excel will only produce binary numbers with up to 10 bits. This means that it can only convert decimal numbers greater than -513 and less than 512.

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.