Documentation/How Tos/Calc: Number Conversion functions

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 13:44, 24 February 2008 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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
OCT2BIN Converts an octal number to
OCT2DEC Converts an octal number to decimal.
OCT2HEX Converts an octal number to hexadecimal.


See also

Functions listed by category

Personal tools