DEC2HEX


Converts a decimal number to hexadecimal.

Syntax:

DEC2HEX(number, numdigits)

returns a hexadecimal number as text, given the decimal number, which must be between -239 and 239-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.

Example:

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.






 
Created with Zapof