< Go Back

Excel HEX2DEC Function

The HEX2DEC function is the function which can convert any hexadecimal value into a decimal value.

What is HEX2DEC function in Excel?

HEX2DEC function in Excel is the one which converts the value entered in the hexadecimal form to the decimal equivalent of the number.

How the HEX2DEC function is used in Excel?

The HEX2DEC function in Excel performs the function of taking a hexadecimal number as input and giving the decimal number as output.

Formula or Syntax of HEX2DEC

=HEX2DEC(number)

Parameters or Arguments of a HEX2DEC function

The HEX2DEC Function has the following arguments:

Number- Mandatory. The Hexadecimal number must be entered first to convert it into a decimal number.

Example

The example of the working of the function is given in the below steps:

  1. At first, enter the hexadecimal values in the A cell. You can add as many values as you want.

 Figure 1. Start entering the Hexadecimal values

  1. Now select the cell in front of the value and insert the HEX2DEC function.
  2. A window will appear where you will have to enter the Hexadecimal value and then tap ok. The decimal value of the number will be returned to the cell which you selected.

Figure 2. Enter the hexadecimal value in the window and tap ok to convert it

Note on Usage of HEX2DEC function

The notes on usage of HEX2DEC Function are:

  •         The number cannot contain more than 10 characters, i.e. 40 bits.
  •         The most important bit is the Sign bit.
  •         Other 39 bits are magnitude bits.
  •         The negative numbers of the value are represented by using two’s complement.
  •         If the number entered is not a valid hexadecimal value then the function will return a #NUM error value in the cell.
Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar