Formulas and functions > Functions from A to Z > BIN2HEX (binary number to hexadecimal number)

Syntax:

BIN2HEX(Number [, Digits])

Description:

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

Number is the number to be converted.

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

Number must not contain more than 32 places, thus the permissible value range is:

-(2^31) ≤ Number ≤ (2^31)-1

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

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:

BIN2HEX("101010") returns 2A

BIN2HEX("00101010") also returns 2A

BIN2HEX("101010", 1) results in the error value #NUM!, as this number can only be represented with at least 2 digits

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