How to use HEX2OCT Function in Excel

The Excel HEX2OCT function converts a hexadecimal number to its octal equivalent.

Syntax: HEX2OCT(number, [places])

The HEX2OCT function syntax has the following arguments:

  • Number    Required. The hexadecimal number you want to convert. Number cannot contain more than 10 characters. The most significant bit of number is the sign bit. The remaining 39 bits are magnitude bits. Negative numbers are represented using two’s-complement notation.
  • Places    Optional. The number of characters to use. If places is omitted, HEX2OCT uses the minimum number of characters necessary. Places is useful for padding the return value with leading 0s (zeros).

Example: Let’s look at some Excel HEX2OCT function examples and explore how to use the HEX2OCT function as a worksheet function in Microsoft Excel:

HEX2OCT Function - How to use HEX2OCT Function in Excel

Syntax:  =HEX2OCT(A2)


HEX2OCT Function in Excel - How to use HEX2OCT Function in Excel

Based on the Excel spreadsheet above, the following HEX2OCT examples would return:

Syntax: =HEX2OCT(A3)
Result: 3777777776

Syntax: =HEX2OCT(A4)
Result: 35516

Syntax: =HEX2OCT(A5)
Result: 7777777400

Syntax: =HEX2OCT(A6)
Result: 4000000000

Syntax: =HEX2OCT(A7)
Result: 4000000001

Syntax: =HEX2OCT(A8)
Result: 7777777000

Syntax: =HEX2OCT(A9)
Result: 10

Syntax: =HEX2OCT(A10,B10)
Result: 00005454

Syntax: =HEX2OCT(A11,B11)
Result: 017

Syntax: =HEX2OCT(A12,B12)
Result: 33

Syntax: =HEX2OCT(A13,B13)
Result: 00000012


  • 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.

Add a Comment

Your email address will not be published. Required fields are marked *