Difference between revisions of "Documentation/How Tos/Calc: Number Conversion functions"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m |
||
Line 39: | Line 39: | ||
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: HEX2OCT function|'''HEX2OCT''']] | |[[Documentation/How_Tos/Calc: HEX2OCT function|'''HEX2OCT''']] | ||
− | |Converts a hexadecimal number to | + | |Converts a hexadecimal number to octal. |
|-valign="top" | |-valign="top" | ||
|[[Documentation/How_Tos/Calc: OCT2BIN function|'''OCT2BIN''']] | |[[Documentation/How_Tos/Calc: OCT2BIN function|'''OCT2BIN''']] | ||
− | |Converts an octal number to | + | |Converts an octal number to binary. |
|-valign="top" | |-valign="top" |
Revision as of 13:45, 24 February 2008
List of Calc Number Conversion functions
The Number Conversion functions convert numbers between forms. Hexadecimal numbers are represented by text. Binary and octal 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. |