Description
Converts a decimal number to hexadecimal.
Syntax
DEC2HEX ( number )
| Parameter | Description |
|---|---|
| number | Decimal integer to convert. |
Remarks
If number is less than -549,755,813,888 or greater than 549,755,813,887, DEC2HEX returns the #NUM! error value.
If number is nonnumeric, DEC2HEX returns the #VALUE! error value.
If number is negative, DEC2HEX 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.
Examples
DEC2HEX(100) returns 64
DEC2HEX(-54) returns FFFFFFCA
See also