Converts a hexadecimal number to its corresponding decimal value.
Syntax:
HEX2DEC(number)
number may be a string of up to ten hexadecimal digits or a number of up to ten digits.
Two's complement representation is used: the highest (fortieth) bit is the sign bit of the hexadecimal number.
Examples:
HEX2DEC("00001000")
returns the number 4096
.
HEX2DEC("FFFFFFFFFF")
returns the number -1
.
Revisions:
This function was added in 2.24.