Formulas > =OCT2DEC()

How To Use OCT2DEC() Function in Google Sheets


Converts a signed octal number to decimal format.

Common Questions about the OCT2DEC Formula:
What does OCT2DEC stand for?
How is the OCT2DEC formula used?
How does the OCT2DEC formula work?

How Can the OCT2DEC Formula be Used Appropriately?
The OCT2DEC formula is used to convert an octal number (base 8) to a decimal number (base 10). This can be useful when working with technical data that is sometimes provided in octal form. It can also be used to convert binary and hexadecimal numbers (base 16) to their decimal equivalents.

How Can the OCT2DEC Formula be Commonly Mistyped?
The most common mistyping of the OCT2DEC formula is typing "DEC2OCT" instead of "OCT2DEC", which will result in an incorrect conversion. Also OT2DC, OCT2DC, OET2DEC, OCT2, OCT2D.

What are Some Common Ways the OCT2DEC Formula is Used Inappropriately?
One common mistake is using the OCT2DEC formula to convert a decimal number to octal. The OCT2DEC formula only supports one-way conversions. Additionally, users may mistakenly use the OCT2DEC formula to convert a negative number into a decimal, which is not supported by the formula.

What Are Some Common Pitfalls When Using the OCT2DEC Formula?
It’s important to remember that the OCT2DEC formula is only used to convert octal numbers to decimal numbers. Trying to convert a decimal number to octal or any other base with the OCT2DEC formula will not yield the desired result. Additionally, when using the formula, ensure that the octal number is properly formatted with a leading “0” for numbers less than eight.

What Are Common Mistakes When Using the OCT2DEC Formula?
Users may forget to add a leading “0” as described above, which can cause an incorrect result. Additionally, users may attempt to use the OCT2DEC formula to convert a character string, which will not work as the formula requires a numerical input.

What Are Common Misconceptions People Might Have With the OCT2DEC Formula?
A common misconception is that the OCT2DEC formula can be used to convert a decimal number to octal, which is not supported. Octal numbers must be converted to binary before they can be converted to decimal.

How To Actually Use OCT2DEC() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the OCT2DEC() formula:

Google Sheet: Number Base Functions

How to convert numbers between different number bases in Google Sheet. The video looks at the generic functions - DECIMAL and BASE which convert from any number base between 2 & 36 and decimal. The video focuses on conversions between the most common number bases using the functions DEC2BIN, DEC2OCT, DEC2HEX, HEX2DEC, OCT2DEC and BIN2DEC. The video demonstrates that Google Sheet can only add, subtract etc numbers in base 10 and shows how sometimes Google Sheet can give the incorrect impression that it can add and subtract numbers in other number bases. Finally the video looks at the maximum and minimum values allowed by each conversion.

Generate a OCT2DEC() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.