OCT2DEC

Syntax:

OCT2DEC ( number )

Description: Makes the decimal equivalent of number.

Arguments:

Name

Type

Description

number

number

A 10-digit octal number in a string that is to be converted to a decimal number. If number has less than 10 digits, leading zero digits are implied until it has exactly 10 digits. The 10 digits use twos-complement representation with the left-most bit (30th bit from the right) representing the sign bit.

Return Type and Value: number – The decimal equivalent of number.

However, if

  • number contains one or more non-octal digits, #NUM! is returned.

  • number contains more than 10 octal digits; that is, number is outside the range "4000000000" (-536,870,912 decimal) to "3777777777" (536,870,911 decimal), inclusive, #NUM! is returned.

example: