Documentation/How Tos/Calc: HEX2DEC function

HEX2DEC

Converts a hexadecimal number to decimal.

This function is only available if the Analysis AddIn is installed.

Syntax:

HEX2DEC(hexadecimalnumber)

returns a (decimal) number, given hexadecimalnumber, which may be text, or a number (taken to be hexadecimal although it is not).

hexadecimalnumber may have up to ten digit in twos complement representation; positive numbers are 0 to 7FFFFFFFFF (representing 0 to 2³⁹-1 decimal) and negative numbers FFFFFFFFFF to 8000000000 (representing -1 to -2³⁹ decimal).

Example:

HEX2DEC("1E")

returns 30 as a (decimal) number.

HEX2DEC(20)

returns 32 as a (decimal) number. The number 20 is read as hexadecimal.

HEX2DEC("FFFFFFFFFE")

returns -2 as a (decimal) number.