Exceljet

Quick, clean, and to the point

Excel HEX2OCT Function

Excel HEX2OCT function
Summary 
The Excel HEX2OCT function converts a hexadecimal number to its octal equivalent.
Purpose 
Converts a hexadecimal number to octal
Return value 
Octal number
Syntax 
=HEX2OCT (number, [places])
Arguments 
  • number - The hexadecimal number you want to convert to octal.
  • places - [optional] Pads the resulting binary number with zeros up to the specified number of digits. If omitted returns the least number of characters required to represent the number.
Version 
Excel 2003
Usage notes 
  • Excel only converts to octal numbers of 10-digits or less, restricting the range of valid input to [0, 7777777777] (octal).
  • The input number must be less than or equal to ten alpha-numeric characters, otherwise the function returns the #NUM! error value.

Negative Numbers

Excel interprets both octal and hexadecimal numbers using two's complement notation. Two's complement notation is a convention that computers use to represent negative numbers in binary.

Example of two's complement for HEX2OCT function
Related functions 
Excel DECIMAL function
Excel DECIMAL Function

The Excel DECIMAL function converts a number in a given base into its decimal number equivalent. For example, the DECIMAL function can convert the binary number 1101 into the decimal number 13.

500 Formulas | 101 Functions

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.