In this article, you will learn about the HEX2DEC function, the formula syntax and usage of the function in Microsoft Excel.
HEX2DEC Function in Excel
The HEX2DEC function in Excel converts a hexadecimal number to its decimal value.
The hexadecimal number you want to convert to a decimal number.
- If the number is not a valid hexadecimal number, HEX2DEC returns the #NUM! error value.
- The input number should be less than or equal to 10 characters, if not the function returns the #NUM! error value.
How to use HEX2DEC in Excel Worksheet?
Using this function in a worksheet is simple; all you need to do is enter the function as a formula of the cell in the formula bar.
Take a look at the given example
The above numbers are the Hexadecimal version of some decimal numbers. To find out the decimal numbers, Enter the given Hexadecimal numbers in column A and in Column B enter the following formula
Here, A1 refers to the cell name or the cell address. Repeat the same to the other cells and you will get the decimal values of the Hexadecimal numbers.