Purpose
Converts a hexadecimal number to octal
Return value
Octal number
Syntax
=HEX2OCT(number,[places])- 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.
Using the HEX2OCT function
- 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.
Related functions
OCT2HEX Function
The Excel OCT2HEX function converts an octal number to its hexadecimal equivalent. For example, the following formula converts the octal number 23 to hexadecimal:
=OCT2HEX(23) // returns 13
HEX2DEC Function
The Excel HEX2DEC function converts a hexadecimal number to its decimal equivalent.
HEX2BIN Function
The Excel HEX2BIN function converts a hexadecimal number to its binary equivalent.
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....
