Implementation for Excel DELTA() function.
Syntax:
DEC2HEX (
number,
places )
Converts a decimal number to hexadecimal.
The decimal integer you want to convert. If number is negative, places is ignored
and this function returns a 10-character (40-bit) hexadecimal number in which the
most significant bit is the sign bit. The remaining 39 bits are magnitude bits.
Negative numbers are represented using two's-complement notation.
- If number < -549,755,813,888 or if number > 549,755,813,887, this function returns the #NUM! error value.
- If number is nonnumeric, this function returns the #VALUE! error value.
places
The number of characters to use. The places argument is useful for padding the
return value with leading 0s (zeros).
- If this argument is omitted, this function uses the minimum number of characters necessary.
- If this function requires more than places characters, it returns the #NUM! error value.
- If this argument is non numeric, this function returns the #VALUE! error value.
- If this argument is negative, this function returns the #NUM! error value.
- If this argument contains a decimal value, this function ignores the numbers to the right side of the decimal point.