The BIN2HEX is an Excel engineering function that converts a binary number to a hexadecimal number. It is one of the oldest Excel functions, so it can be used even with Excel 2003.

**Note: ** Other conversion functions are BIN2DEC (binary to decimal), BIN2OCT (binary to octal) and HEX2BIN (hexadecimal to binary)

## Syntax

BIN2HEX(number, [places])

## Required Arguments

[**number**]: The binary number that you want to convert. Note that there’s a limit of 10 characters i.e 10 bits.

## Optional Arguments

[**places**]: How many characters should the output contain. If omitted, minimum number of characters necessary will be used.

## BIN2HEX Function Examples

BIN2HEX(1) = 1

BIN2HEX(10, 7) = 0000002

BIN2HEX(11, 1) = 3

BIN2HEX(11010101) = D5

## Common Errors

Most common errors with this function are:

### #VALUE

- [places] argument is non-numeric

### #NUM

- The number is either longer than 10 characters or is not a binary number.
- [places] argument is less than 0 or more than 10
- The output needs more numbers than the [places] argument would allow. I.e if you’ve set it to 1 but the resulting hexadecimal is D5.

## How to Reverse BIN2HEX?

The easiest way to reverse it is to use a built-in Excel function- HEX2BIN. It works the same way.

## More Examples and Use Cases

We don’t have any use cases for this formula on our website at this moment but will link them below once we have. Stay tuned!