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

Number: The Binary number you want to convert. It is required. Places: the number of characters to use it is optional. How to use the BIN2HEX function in 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.