OCT2DEC

  • Updated

Converts an octal number to decimal.

Sample Usage

OCTDEC(101)
OCT2DEC(C5)

Syntax

OCT2DEC(number)

  • number - The octal number to be converted.

Examples

OCT2DEC(101) returns a value of 65.
OCT2DEC(C5) converts the octal number contained in C5 to decimal.

 Notes

  • If number is negative, the value of places is ignored and OCT2DEC returns a 10-character decimal number. 
  • number cannot contain more than 10 characters.
  • number can have a maximum value of 777 if positive, and a minimum of 7777777000 if negative. 
  • If number is not a valid octal number, OCT2DEC returns the #NUM! error value.
  • If places is not an integer, it is truncated.
  • If places is non-numeric, OCT2DEC returns the #VALUE! error value.
  • If places is negative, OCT2DEC returns the #NUM! error value.
  • If the number of digits required is greater than the specified places, the #NUM! error is returned.