DEC2OCT Function

how to use dec2oct function in excel

You can convert decimal numbers into octal numbers
Octal numbers contain 0 to 7 values

DEC2OCT Function has a limit of eight times "9"
If you write nine times "9" characters it will return #NUM error




Number: it is the number you want to convert into octal
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.


Here we have taken an example of the decimal number and convert it into octal numbers.
We have written a formula  

=DEC2OCT(D4,4) which will convert the decimal number into octal numbers

On the right side, if you write eight times "9" it will return "575360377"
If you write nine times "9" it will return #NUM error because it is the limit of the Function


To convert an Decimal number into a Octal number


Octal number

No comments:

Post a Comment