Negative Values

Excel internally represents Hexadecimal numbers in binary using 40 bits.

The first bit indicates whether the number is positive or negative.

The remaining bits indicate the magnitude of the number.

Range of DEC2HEX function

Negative numbers are internally represented in binary using two’s complement notation.

For example, the DECIMAL function can convert the binary number 1101 into the decimal number 13.

Range of DEC2HEX function

Range of DEC2HEX function

Range of DEC2HEX function

Range of DEC2HEX function

Excel DECIMAL function

Range of DEC2HEX function