Documentation/How Tos/Calc: HEX2DEC function
From Apache OpenOffice Wiki
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 239-1 decimal) and negative numbers FFFFFFFFFF to 8000000000 (representing -1 to -239 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.