Excel BIN2HEX Function

Using the Excel BIN2HEX Function


The Excel BIN2HEX function converts a binary number to a hexadecimal.


=BIN2HEX (number, [places])

Syntax Breakdown

Required. The number, in binary format, that you wish to convert to a hexadecimal. Negative numbers are represented using two's-complement notation. Number must be less than 10 characters (10 bits).

If the number argument is negative, the function will ignore the places argument and return a 10-character hexadecimal value.

Optional. The number of characters to use. If omitted, the function uses the minimum number of places necessary. Entries that are not integers will be truncated.

Usage Notes

BIN2HEX converts a number from binary to its hexadecimal equivalent. The first bit indicates if the number is negative or positive. The remaining 9 digits represent the actual number.

BIN2HEX Errors
The function will return an error in the following instances:

1) The function returns the #NUM! error if number isn't a valid binary number or if number is greater than 10 characters (10 bits)

2) If the places argument is non-numeric, the function returns the #VALUE! error

3) If the places argument is negative, the function returns the #NUM! error