Formulas > =HEX2OCT()

How To Use HEX2OCT() Function in Google Sheets


Converts a signed hexadecimal number to signed octal format.

Common questions about the HEX2OCT formula include:

- What does the HEX2OCT formula do? 
- How do I write the HEX2OCT formula? 
- What are the parameters for the HEX2OCT formula? 

The HEX2OCT formula can be used appropriately to convert a hexadecimal number to its octal equivalent.

The HEX2OCT formula is sometimes mistyped as ""HEX2EIGHT"" or ""HEX2OCTAL"".

Some common ways the HEX2OCT formula is used inappropriately include attempting to use it with a non-hexadecimal number or attempting to convert a non-numeric string to an octal value.

Common pitfalls when using the HEX2OCT formula include forgeting to capitalize the ""O"" in the formula or forgetting to include the parentheses around the hexadecimal argument. 

Common mistakes when using the HEX2OCT formula include attempting to use the formula with a character or string that is not a hexadecimal value or forgetting to include the cell reference that contains the hexadecimal number.

Common misconceptions people might have with the HEX2OCT Formula include thinking that it can be used to convert any Non-Hexadecimal number to its octal equivalent or that it will not work with negative hexadecimal numbers.

How To Actually Use HEX2OCT() in Sheets

HEX2OCT(signed_hexadecimal_number, significant_digits)

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 HEX2OCT() 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 HEX2OCT() 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.