Difference between revisions of "Documentation/How Tos/Calc: HEX2DEC function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m |
||
(3 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE:HEX2DEC function}} |
+ | {{Documentation/CalcFunc Number ConvTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_HEX2BIN_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_HEX2OCT_function | ||
+ | }}__NOTOC__ | ||
== HEX2DEC == | == HEX2DEC == | ||
Line 8: | Line 13: | ||
=== Syntax: === | === Syntax: === | ||
<tt>'''HEX2DEC(hexadecimalnumber)'''</tt> | <tt>'''HEX2DEC(hexadecimalnumber)'''</tt> | ||
− | : returns a (decimal) number, given <tt>'''hexadecimalnumber'''</tt>, which may be text, or a number (taken to be hexadecimal although it is not). | + | : returns a (decimal) number, given <tt>'''hexadecimalnumber'''</tt>, which may be text, or a number (taken to be hexadecimal, although it is not). |
: <tt>'''hexadecimalnumber'''</tt> may have up to ten digits in two's complement representation; positive numbers are 0 to 7FFFFFFFFF (representing 0 to 2<sup>39</sup>-1 decimal) and negative numbers FFFFFFFFFF to 8000000000 (representing -1 to -2<sup>39</sup> decimal). | : <tt>'''hexadecimalnumber'''</tt> may have up to ten digits in two's complement representation; positive numbers are 0 to 7FFFFFFFFF (representing 0 to 2<sup>39</sup>-1 decimal) and negative numbers FFFFFFFFFF to 8000000000 (representing -1 to -2<sup>39</sup> decimal). | ||
Line 23: | Line 28: | ||
<tt>'''HEX2DEC(20)'''</tt> | <tt>'''HEX2DEC(20)'''</tt> | ||
− | : returns <tt>'''32'''</tt> as a (decimal) number. The number <tt>'''20'''</tt> is read as hexadecimal. This is not | + | : returns <tt>'''32'''</tt> as a (decimal) number. The number <tt>'''20'''</tt> is read as hexadecimal. This is not recommended since changing the parameter to '''1F''' without double quotes will result in HEX2DEC converting the parameter to '''F1''' and doing a cell lookup. |
− | {{ | + | {{SeeAlso|EN| |
* [[Documentation/How_Tos/Calc: BIN2DEC function|BIN2DEC]] | * [[Documentation/How_Tos/Calc: BIN2DEC function|BIN2DEC]] | ||
* [[Documentation/How_Tos/Calc: BIN2HEX function|BIN2HEX]] | * [[Documentation/How_Tos/Calc: BIN2HEX function|BIN2HEX]] | ||
Line 44: | Line 49: | ||
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
− | [[Category: Documentation/Reference/Calc]] | + | [[Category: Documentation/Reference/Calc/Number Conversion functions]] |