This Excel tutorial explains how to use the Excel BIN2HEX function with syntax and examples.
places is optional. It is the number of characters to use when displaying the results. It will pad the front of the result with 0's to fill the characters, if necessary.
Based on the spreadsheet above, the following Excel BIN2HEX examples would return:
Description
The Microsoft Excel BIN2HEX function converts a binary number to a hexadecimal number.Syntax
The syntax for the Microsoft Excel BIN2HEX function is:BIN2HEX( binary_number, [places] )
Parameters or Arguments
binary_number is the binary number that you wish to convert to a hexadecimal number.places is optional. It is the number of characters to use when displaying the results. It will pad the front of the result with 0's to fill the characters, if necessary.
Applies To
The BIN2HEX function can be used in the following versions of Microsoft Excel:- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007
Type of Excel Function
The BIN2HEX function can be used in Microsoft Excel as the following type of function:- Worksheet function (WS)
Example (as Worksheet Function)
Let's look at some Excel BIN2HEX function examples and explore how to use the BIN2HEX function as a worksheet function in Microsoft Excel:Based on the spreadsheet above, the following Excel BIN2HEX examples would return:
=BIN2HEX(A1) Result: 3B =BIN2HEX(111011) Result: 3B =BIN2HEX(A2) Result: 14 =BIN2HEX(10100) Result: 14 =BIN2HEX(111111) Result: 3F =BIN2HEX(111111, 4) Result: 003F =BIN2HEX(111111, 5) Result: 0003F
