HEX2DEC Function in Excel

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.

Subscribe to Blog via Email