Learn How to Use Microsoft Excel DEC2HEX Function

Microsoft Excel DEC2HEX Function

The prime function of the Microsoft Excel DEC2HEX function is to convert decimal numbers to its hexadecimal equivalent. That means with the help of the DEC2HEX function you can able to convert a decimal number that represents its hexadecimal equivalent.              

Return Value of DEC2HEX Function

The return value will be the hexadecimal number.

Syntax of DEC2HEX Function

=DEC2HEX(number, [places])

Where the arguments:

• number: It is the decimal number that you want to convert into hexadecimal equivalent.
• places: Holds the resulting hexadecimal number with zeros up to the specified number of digits. In case omitted returns the least number of characters required to represent the number (optional).

How to Use Microsoft Excel DEC2HEX Function?

As we know that DEC2HEX function used to convert the specified decimal number to its hexadecimal counterpart. Just make sure that the input must be the valid decimal number within the range of -2^39 to 2^39 - 1. 

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel