HEX2DEC function
HEX2DEC converts a hexadecimal number to a decimal number.
Syntax
HEX2DEC(number )
Number is a hexadecimal number. The number can have a maximum of 10 places. The most significant bit is the sign bit, the following bits return the value. Negative numbers are entered as two's complement.
Example
=HEX2DEC(64) returns 100.