HEX2DEC Function

The HEX2DEC () is an engineering function which takes number as argument and converts a hexadecimal number to a decimal number.

Formula:


=HEX2DEC (number)
In the above syntax, the argument number denotes the hexadecimal number to be converted. The Number should not be more than 10 digits. The most significant bit of number is the sign bit and the remaining 39 bits are magnitude bits. Negative numbers are represented using two's-complement notation.

Video Tutorial:


Let us see how the HEX2DEC function converts a hexadecimal number to a decimal number with the help of the below video.

Learn MS Excel


Ask Questions

Ask Question