Microsoft Excel offers some very effective functions to work with numbers. One such function is the HEX2DEC function. The HEX2DEC function converts a hexadecimal number to its decimal counterpart. In this tutorial, we will learn how to use the HEX2DEC function in Excel.
Figure 1. Example of How to Use the HEX2DEC Function in Excel
Syntax for HEX2DEC function
Required. This is the hexadecimal number that is converted to a decimal number.
Setting up Data
The following example data set consisting of hexadecimal numbers. The numbers are in column A. We will be converting these numbers to their decimal equivalents. The results will be in column B.
Figure 2. Setting up Data to Use the HEX2DEC Function in Excel
In order to do that:
- We need to click cell B2 with the mouse.
- Assign the formula
=HEX2DEX(A2)to the formula bar of cell B2.
- Press Enter.
Figure 3. Applying the HEX2DEC Function in Excel
- Drag the fill handle from cell B2 from B2 to B5.
This will convert the hexadecimal numbers in column A to decimal numbers in column B.
- The number argument can have up to 10 characters (40 bits). The sign bit is the most significant bit of the number. The other 39 bits are used as magnitude bits. Excel represents negative numbers using two’s-complement notation.
- The HEX2DEC function returns a #NUM! error if the number is not a hexadecimal number.
- The function returns a #NUM! error if the number resembles >=3^23.
Figure 4. Example of Common Errors with the HEX2DEC Function in Excel
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.