How to use HEX2BIN Function in Excel

The Excel Hex2Bin function converts a Hexadecimal (Base 16) number into a Binary (Base 2) number

Syntax: HEX2BIN(number, [places])

The HEX2BIN function syntax has the following arguments:

  • Number    Required. The hexadecimal number you want to convert. Number cannot contain more than 10 characters. The most significant bit of number is the sign bit (40th bit from the right). The remaining 9 bits are magnitude bits. Negative numbers are represented using two’s-complement notation.
  • Places    Optional. The number of characters to use. If places is omitted, HEX2BIN uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros).

Example: Let’s look at some Excel HEX2BIN function examples and explore how to use the HEX2BIN function as a worksheet function in Microsoft Excel:

HEX2BIN Function - How to use HEX2BIN Function in Excel

Syntax:  =HEX2BIN(A2)

Result:

HEX2BIN Function in Excel - How to use HEX2BIN Function in Excel

Based on the Excel spreadsheet above, the following HEX2BIN examples would return:

Syntax: =HEX2BIN(A3)
Result: 1111

Syntax: =HEX2BIN(A4)
Result: 10011

Syntax: =HEX2BIN(A5)
Result: 10

Syntax: =HEX2BIN(A6)
Result: 111111111

Syntax: =HEX2BIN(A7)
Result: 1111111111

Syntax: =HEX2BIN(A8)
Result: 1000000000

Syntax: =HEX2BIN(A9,B9)
Result: 0000000010

Syntax: =HEX2BIN(A10,B10)
Result: 11101

Syntax: =HEX2BIN(A11,B11)
Result: 00001111

Syntax: =HEX2BIN(A12,B12)
Result: 00001111

Syntax: =HEX2BIN(A13,B13)
Result: 00001010

Note:

  • Excel only converts to binary numbers of 10-digits or less, restricting the input range to [-512, 511] (decimal).
  • The input number must be less than or equal to ten alpha-numeric characters, otherwise the function returns the #NUM! error value.
  • The internal (binary) representation of the hexadecimal number uses two’s complement notation. The first bit indicates whether the number is positive or negative, and the other 39 bits indicate the magnitude of the number.

Add a Comment

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