public final Class Dec2Hex

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.

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.