# How to Use Excel BIN2HEX Function?

Excel BIN2HEX Function: Excel is a spreadsheet program that is developed for WindowsMacAndroid, and iOS. It helps to perform calculations on your PC. Sometimes, we want to use the Binary value in our data and want to convert them into hexadecimal values. At that time, we can use a built-in function to do that.

Today, we will see how to use Excel BIN2HEX Function in the worksheet. This function will convert the binary values to hexadecimal values. Let’s see the Definition, syntax, and examples of the BIN2HEX function. Get the official version of MS Excel from the following link:

## Description of BIN2HEX Function

• The BIN2HEX function is one of the built-in functions in Excel.
• This function is used to convert binary numbers to hexadecimal numbers in Excel.
• If the binary number has more than ten characters, it will return #NUM! Error value.
• If you give the negative number, this function ignores places and replaces the ten-character hexadecimal numbers.

## Syntax

• Here, you will see the syntax of the BIN2HEX function.
• To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
• Once you enter the formula, just click on the button to get the result.

=BIN2HEX (number, [places])

Argument Description

Number – The binary number that you want to convert into hexadecimal numbers.

Places – It is optional. If places are not given, then it will return the exact hexadecimal value to the input number. It is mainly used for padding the return values with leading zeros.

Note:
1) If places are not an integer, it will return #VALUE! Error.
2) If you give any non-numeric numbers in the places argument, it will return #VALUE! Error.
3) In case, if you give a negative value to places, it will return #NUM! Error value.

## Examples

Let’s see some examples to know how to use the BIN2HEX function in Microsoft Excel.

• Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
• You need to know that, the first bit of the binary number shows whether it is a positive number or a negative number. If the binary value starts at 0, it is a positive number.
• In case, the Binary value starts at 1, it will be a negative value. In the following example, we have entered both positive and negative values for your reference.
• You have to enter the formula in the cell as shown below to get the result.
• After entering the formula, you need to click the button to get the output, as shown below. You can drag down the cell to fill the remaining cells.

## Input that Causes Error

• As we already said, if you give a negative value to places, it will return #NUM! Error value.
• If you give any non-numeric numbers in the places argument, it will return #VALUE! Error.