A BIN2Hex function is an engineering function in Microsoft Excel, and its purpose is to convert a decimal to hexadecimal. The hexadecimal is a number system that uses 16 unique alpha-numeric symbols to represent a particular value. The formula for the Bin2Hex function is BIN2HEX(number, [places]).
What is the syntax of a function in Excel?
The syntax for the BIN2HEX function is as below:
- Number: The Binary number you want to convert. It is required.
- Places: the number of characters to use it is optional.
How to use the BIN2HEX function in Excel
To use the BIN2HEX function to convert a binary or decimal to hexadecimal in Excel, follow the steps below:
- Launch Excel
- Create a table or use an existing table
- Type the formula BIN2HEX into the cell you want to place the result.
- Press Enter to see the result
Launch Microsoft Excel.
Create a table with headings Binary and Hex, or use an existing one.
Under the hex heading type =BIN2HEX(A2,5).
A2 is the Binary number you want to convert.
5 is the number of characters we want to use to display the result of the hexadecimal.
Then press Enter to see the result.
To see the results of the others.
Drag the fill handle down.
Related: How to create online survey using Forms for Excel on OneDrive.
There are two other methods to use the BIN2HEX function in Excel.
Method one is to click the fx button on the top left of the Excel worksheet.
An Insert Function dialog box will appear.
Inside the dialog box in the section, Select a Category, select Engineering from the list box.
In the section Select a Function, choose the BIN2HEX function from the list.
Then click OK.
A Function Arguments dialog box will open.
In the Number section, input into the box the cell A2.
In the Places section, input 5 into the box.
Then click OK to see the result.
Method two is to click the Formulas tab and click the More Functions button in the Function Library group.
In the list, hover the cursor over Engineering and select BIN2HEX.
A Function Arguments dialog box will appear.
Follow the steps in method one for Function Arguments.
We hope this tutorial helps you understand how to use the BIN2HEX function in Microsoft Excel; if you have questions about the tutorial, let us know in the comments.
Read next: How to Unpivot Static Tables in Microsoft Excel.
