BIN2HEX Function in Excel converts Binary number to a Hexadecimal number.
Syntax of BIN2HEX Function in Excel (BINARY TO HEXADECIMAL FUNCTION IN EXCEL):
BIN2HEX(number,[places])
Where
- number – The binary number that is to be converted to a Hexadecimal.
- [places] – An optional argument that specifies how many digits needs to be returned.
Example of BIN2HEX Function in Excel (BINARY TO HEXADECIMAL FUNCTION IN EXCEL):
Formula:
- The supplied binary value should not have more than 10 character
- In row number 4, BIN2HEX Function takes up [places] argument as 6 which returns the 6 digits with 4 preceding Zeros i.e. 000015.
Result:
Note:
#NUM! – Error occurs if the supplied number argument is not recognized as a binary number, or contains more than 10 characters.