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.
