Skip to content

How to Use Excel BIN2HEX Function?

BIN2HEX FunctionPin
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:

Use Excel BIN2HEX functionPin
Use Excel BIN2HEX function

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.


  • 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 Enter 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.

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.


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.
Enter the formulaPin
Enter the formula
  • After entering the formula, you need to click the Enter 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.


In the above article, you can understand the usage of the BIN2HEX Function in Excel with examples. Kindly drop your feedback in the comment section. To learn more about Excel functions, then visit our webpage

Video Tutorial

The following video will show you how to apply the BIN2HEX function on your Excel spreadsheet.

Keep Reading:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...