OCT2DEC(number)

Returns the number converted from octal to decimal.

numberThe octal number you want to convert.

Remarks

* If "number" is not a valid octal number, then #NUM! is returned.
* If "number" contains more than 10 characters (10 bits), then #NUM! is returned.
* If "number" does not contain more than 10 octal characters (30 bits), then the most significant bit of number is the sign bit. The remaining 29 bits are magnitude bits.
* Any negative numbers are represented using two's-complement notation.
* You can use the OCT2BIN function to convert a number from octal to binary.
* You can use the OCT2HEX function to convert a number from octal to hexadecimal.
* You can use the DEC2OCT function to convert a number from decimal to octal.
* In Excel 2007 the accuracy of this function was improved.
* In Excel 2003 this function was only available when you had the Analysis ToolPak add-in loaded.
* For the Microsoft documentation refer to support.office.com

 A
1=OCT2DEC(54) = 44
2=OCT2DEC("54") = 44
3=OCT2DEC(7777777533) = -165
4=OCT2DEC(123456789123) = #NUM!
5=OCT2DEC("some text") = #NUM!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top