HEX2DEC

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.