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.
Syntax
=HEX2DEC(number)
Arguments:
- Number
The hexadecimal number you want to convert to a decimal number.
Possible Errors
- 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
Formula: =HEX2DEC(A1)
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.
