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.

Remember that each binary number is eight digits long (2^8=256), unless you decide to drop the leading zeros. You might want to find a shorter phrase or a bigger arm!] More options ...

This will convert the digit from Decimal to Binary. For example, I opted to convert 2015 into Binary, and the converted digit came to 11111011111. You can also add Windows Calculator to Excel ...

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.

Another way to convert a denary number to binary is to divide the starting number by two. If it divides evenly, the binary digit is 0. If it does not and there is a remainder, the binary digit is 1.