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 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 ...

Then click OK. A Function Arguments dialog box will open. In the Number section, input into the box the cell A2. In the Places section, input 5 into the box. Then click OK to see the result.