# 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.