Excel OCT2DEC Function

If you want to follow along with this tutorial, please download the example spreadsheet.

Description

The Excel OCT2DEC function converts an octal number to a decimal number.

Syntax and arguments

Formula syntax

Arguments

Number: Required, the octal number that needs to be converted to a decimal number. The number may not contain more than 10 characters (30-bits). The most significant bits of the number indicates if the number is positive or negative, the remaining bits indicate the magnitude of the number. Negative numbers are represented using two’s-complement notation.

Return Value

The OCT2DEC function returns a decimal number.

Error

Return #NUM! error if the argument number is > 777 or < 7777777000 or an invalid octal value.

Version

Excel 2003 and later versions

Usage and Examples

Example

There is a list of octal numbers placed in B:B10, to get the corresponding decimal numbers, please copy or enter the below formula to the next cell of the range:

=OCT2DEC(B4)

Press Enter key and drag the auto-fill handle down to get all decimal numbers.

If you just use the formula once, you also can directly type arguments in the formula:

=OCT2DEC(0)

---

Relative Functions:

• Excel OCT2BIN Function
  The Excel OCT2BIN function converts an octal number to a binary number.

• Excel BIN2HEX Function
  The BIN2HEX function converts a binary number to a hexadecimal number.

• Excel BIN2OCT Function
  The BIN2OCT function converts a binary number to an octal number.

• Excel HEX2DEC Function
  The Excel HEX2DEC function converts a hexadecimal number to a decimal integer number.