Difference between revisions of "Documentation/How Tos/Calc: Number Conversion functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also) |
(→See also) |
||
Line 72: | Line 72: | ||
<!-- why on earth is this necessary? --> | <!-- why on earth is this necessary? --> | ||
− | + | {{Documentation/SeeAlso| | |
− | [[Documentation/How_Tos/Calc: DOLLAR function| | + | * [[Documentation/How_Tos/Calc: DOLLAR function|DOLLAR]], [[Documentation/How_Tos/Calc: VALUE function|VALUE]] <br> in [[Documentation/How_Tos/Calc: Text functions|Text functions]] |
− | [[Documentation/How_Tos/Calc: VALUE function| | + | |
− | in | + | |
− | [[Documentation/How_Tos/Calc: DOLLARDE function| | + | * [[Documentation/How_Tos/Calc: DOLLARDE function|DOLLARDE]], [[Documentation/How_Tos/Calc: DOLLARFR function|DOLLARFR]] <br> in [[Documentation/How_Tos/Calc: Financial functions|Financial functions]] |
− | [[Documentation/How_Tos/Calc: DOLLARFR function| | + | |
− | in | + | |
− | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]], |
− | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]] |
+ | }} |
Revision as of 09:23, 3 March 2009
List of Calc Number Conversion functions
The Number Conversion functions convert numbers between forms. Binary, octal and hexadecimal numbers may be represented by text, or by numbers using only valid digits (0-1 for binary, 0-7 for octal); this is only a representation, and arithmetic (eg addition) will not work. Calc functions return text for binary, octal and hexadecimal numbers.
BIN2DEC | Converts a binary number to decimal. |
BIN2HEX | Converts a binary number to hexadecimal. |
BIN2OCT | Converts a binary number to octal. |
DEC2BIN | Converts a decimal number to binary. |
DEC2HEX | Converts a decimal number to hexadecimal. |
DEC2OCT | Converts a decimal number to octal. |
HEX2BIN | Converts a hexadecimal number to binary. |
HEX2DEC | Converts a hexadecimal number to decimal. |
HEX2OCT | Converts a hexadecimal number to octal. |
OCT2BIN | Converts an octal number to binary. |
OCT2DEC | Converts an octal number to decimal. |
OCT2HEX | Converts an octal number to hexadecimal.
|
ARABIC | returns an Arabic number (eg 14), given a Roman number (eg XIV). |
BAHTTEXT | returns Thai text, given a number. |
DECIMAL | returns a decimal number, given a text representation and its base radix. |
ROMAN | returns a Roman numeral (eg XIV), given a number. |