HEX2BIN (hexadecimal number to binary number)

<< Click to Display Table of Contents >>

HEX2BIN (hexadecimal number to binary number)

Syntax:

HEX2BIN(Number [, Digits])

Description:

Converts the given hexadecimal number (base 16) to a binary number (base 2).

Number is the number to be converted.

Negative numbers have to be transformed to two's complement notation (see last example).

The permissible value range for Number is (in hexadecimal notation):

80000000 ≤ Number ≤ 7FFFFFFF

This corresponds in decimal notation:

-2,147,483,648 ≤ Number ≤ 2,147,483,647

The optional argument Digits lets you specify the number of places to be displayed. If omitted, PlanMaker determines the number of required places automatically.

Digits must be greater than zero. Digits should be an integer. Digits to the right of the decimal point are ignored.

If Digits is smaller than the minimum number of places required to display the number, the function returns a #NUM error value.

If Number is negative, the result is represented in 32-bit two's complement; the Digits argument is ignored in this case.

Example:

HEX2BIN("2A") returns 101010

HEX2BIN("2A", 8) returns 00101010

HEX2BIN("2A", 2) returns the error value #NUM!, because this number cannot be represented with fewer than 5 binary digits

HEX2BIN("FFFFFFD6") returns 11111111111111111111111111010110 (negative value)

See also:

BIN2HEX, HEX2DEC, HEX2OCT