Converts the specified decimal number to its hexadecimal equivalent.
Syntax
 Copy Code
|
|---|
DEC2HEX( NumberOrText x, [Integer digits] ) → Text |
Parameters
- x
- Required. The decimal number to convert, expressed as either text or number.
- digits
- Optional. The number of characters to use for the result, useful for padding the return value with leading zeros.
Remarks
If x is less than -2^39 or greater than 2^39-1, the function returns the #NUM! error value. If x is non-numeric, the function returns the #VALUE! error value.
If digits is omitted, the function uses the minimum number of characters necessary. If digits is specified and is less than the number of characters required to represent the result, the function returns the #NUM! error value. If digits is negative or greater than 10, the return value is #NUM!. If digits is not an integer number, it is truncated.
Example
| Formula
Copy Code
|
|---|
=DEC2HEX(11,4) |
See Also
Function Reference
BIN2DEC Function
HEX2DEC Function
OCT2DEC Function