DEC2HEX function

FUNCTIONS

DEC2HEX

Converts a decimal number to hexadecimal.

This function is only available if the Analysis AddIn is installed.

DEC2HEX(number; numdigits)

returns a hexadecimal number as text, given the decimal number, which must be between -2³⁹ and 2³⁹-1 inclusive, and may be text or a number.

The output is a hexadecimal number with up to ten digits in two's complement representation.

numdigits is an optional number specifying the number of digits to return.

DEC2HEX(30)

returns 1E as text.

DEC2HEX("30")

returns 1E as text. DEC2HEX will accept a decimal number given as text.

DEC2HEX(30; 4)

returns 001E as text. Leading zeroes are added to make 4 digits.

DEC2HEX(-2)

returns FFFFFFFFFE as text.

See Also