Documentation/How Tos/Calc: Number Conversion functions

From Apache OpenOffice Wiki
Jump to: navigation, search



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.




See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_Number_Conversion_functions&oldid=243453"
Views
Personal tools
Navigation
Tools