Excel Guides

Converting to Octal in Excel

To convert a number to octal in Excel, firstly determine the number of digits in the octal number. Octal numbers have a base of 8, so there are 8 digits in each octal number. Secondly, divide the decimal number by 8 and take the remainder. This will be the first digit in the octal number. Thirdly, divide the decimal number by 8 and take the remainder. This will be the second digit in the octal number.

Fourthly, continue dividing the decimal number by 8 and taking the remainders until there are no more digits left in the decimal number. The final remainders will make up the octal number from right to left.

For example, to convert the decimal number 25 to octal, divide 25 by 8 and take the remainder, which is 1. 1 will be the first digit in the octal number. Divide 25 by 8 again and take the remainder, which is 4. 4 will be the second digit in the octal number.

Since there are no more digits left in 25 after division by 8 twice, the final octal number will be 14.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.