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

Decimal notation describes numbers using the digits 1 through 10. Binary notation describes them using just two digits, 1 and 0, where each bit in a string represents a power of 2. The right-most bit ...

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.