http://docs.google.com/support/bin/answer.py?hl=en&funcType=engineering&answer=82712


FunctionSyntaxDescription
Binary to decimalBIN2DEC(number)

Converts a binary number to its decimal value.

View example (in new window )

Hide example | View in new window

Binary to hexadecimalBIN2HEX(number, places)

Converts a binary number to its hexadecimal value. Places (optional) is the number of characters to use in the result. If it is larger than the number, it will pad the result with leading zeros.

Binary to octalBIN2OCT(number, places)

Converts a binary number to its octal value. Places (optional) is the number of characters to use in the result. If it is larger than the number, it will pad the result with leading zeros.

Decimal to binaryDEC2BIN(number, places)

Converts a decimal number to its binary value. Places (optional) is the number of characters to use in the result. If it is larger than the number, it will pad the result with leading zeros.

Decimal to hexadecimalDEC2HEX(number, places)

Converts a decimal number to its hexadecimal value. Places (optional) is the number of characters to use in the result. If it is larger than the number, it will pad the result with leading zeros.

Decimal to octalDEC2OCT(number, places)

Converts a decimal number to its octal value. Places (optional) is the number of characters to use in the result. If it is larger than the number, it will pad the result with leading zeros.

Hexadecimal to binaryHEX2BIN(number, places)

Converts a hexadecimal number to its binary value. Places (optional) is the number of characters to use in the result. If it is larger than the number, it will pad the result with leading zeros.

Hexadecimal to decimalHEX2DEC(number)

Converts a hexadecimal number to its decimal value.

Hexadecimal to octalHEX2OCT(number, places)

Converts a hexadecimal number to its octal value. Places (optional) is the number of characters to use in the result. If it is larger than the number, it will pad the result with leading zeros.

Octal to binaryOCT2BIN(number, places)

Converts an octal number to its binary value. Places (optional) is the number of characters to use in the result. If it is larger than the number, it will pad the result with leading zeros.

Octal to decimalOCT2DEC(number)

Converts an octal number to its decimal value.

Octal to hexadecimalOCT2HEX(number, places)

Converts an octal number to its hexadecimal value. Places (optional) is the number of characters to use in the result. If it is larger than the number, it will pad the result with leading zeros.