Menu
EXCEL DEC2HEX FUNCTION
Excel DEC2HEX Function Introduction
The Dec2Hex function in Excel transforms decimal numbers to Hexadecimal (Base 16) numbers.
Description of Excel DEC2HEX Function
Syntax :
=DEC2HEX ( number, [places] )
Parameters :
The following are the function arguments:
Number :
- The decimal value to be translated to hexadecimal.
Places :
- An optional parameter specifying the amount of characters in the returned hexadecimal number.
- If this value is more than zero, the hexadecimal number will be padded with leading zeros.
- If [places] is not specified, the returned hexadecimal has the fewest amount of places.
Step By Step Guide of DEC2HEX Function
Example :
Examples of the Dec2Hex Function The spreadsheets below illustrate five different uses for the Excel Dec2Hex function.
Key Points
- #NUM! – Occurs if the given number argument is either -549,755,813,888 or more than 549,755,813,887; The generated hexadecimal number requires more places than the given [places] parameter specifies; the supplied [places] argument is 0 or more than 10.
- #VALUE! – Occurs if either the specified number or [places] argument is non-numeric.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
