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

If you're using Excel to calculate monetary values, then you only have to worry about two decimal places in your numbers. Aligning your numbers to the right automatically lines up the decimal points ...