Enter the number you wish to convert. For example, if you want to convert 100 to binary, type "100" without quotes. Type a comma. Enter the number of bits you wish your binary number to contain.

Decimal numbers between 100 and 109 would be represented in BCD by the actual number + 156 (26*6). Numbers between 110 and 119 convert to BCD values of the actual number + 156 + 6.

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