Excel DEC2HEX function

Function              DEC2HEX

Description        Excel DEC2HEX function converts Decimal number system to Hexadecimal number system.

Syntax                  DEC2HEX(number, [places])

Number               is the decimal number

[places]               Optional. Which specifies the number of characters that you want the returned hexadecimal number to have. If omitted returns the least number of characters required to represent the number.

Example:

Usage Notes:

• If Number is less than -549,755,813,888 (-2^39) or greater than 549,755,813,887(2^39-1), DEC2HEX returns the #NUM! error value.
• If Number is non-numeric, DEC2HEX returns the #VALUE! error value.
• If the result of DEC2HEX requires more than the number of specified Places characters, it returns the #NUM! error value.
• If places is not an integer, it shows #NAME? error.
• If Places is non-numeric, DEC2HEX returns the #VALUE! error value.
• If Places is negative, DEC2HEX returns the #NUM! error value.