**Using the Excel BIN2HEX Function**

## Summary

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

=BIN2HEX (number, [places])## Syntax Breakdown

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

**Places**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