HEX2BIN Function

how to use hex2bin function in excel

You can convert hexadecimal numbers into binary numbers
The binary numbers contain only 0 and 1 values
Hexadecimal numbers contain 0 to 15 values

HEX2BIN Function has a limit of 10 characters(1FF in HEX) in binary numbers

If you write more than 10 characters(More then 1FF) it will return #NUM error




Number: it is the number you want to convert into binary
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.


Here we have taken an example of the Hexadecimal number and convert it into Binary numbers. We have written a formula 

=HEX2BINJ(D4,10) which will convert the binary number into hexadecimal and show result till 10 characters. No character place is filled by 0

On the right side, if you write 1FF it will return "111111111"
If you write more than 1FF(2FF and more) characters it will return #NUM error


To convert a HExadecimal number into a Binary number


Binary number

No comments:

Post a Comment