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:
Syntax: =HEX2OCT(A2)
Result:
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
Note:
- 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.