Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The HEX2OCT function converts a hexadecimal number to its octal equivalent. This is useful in various applications, especially in computing and digital electronics, where octal representation is sometimes used.
Syntax
HEX2OCT(number, [places])
The HEX2OCT function syntax has the following arguments:
- number Required. The hexadecimal number you want to convert to octal. It must be a valid hexadecimal string.
- places Optional. The number of characters to use for the octal result. If omitted, the function returns the minimum number of characters necessary to represent the number in octal.
Example
| Formula | Description | Result |
| =HEX2OCT("A") | Converts the hexadecimal number "A" to octal. | 12 |
| =HEX2OCT("FF") | Converts the hexadecimal number "FF" to octal. | 377 |
Errors
For a full list of formula errors, please read Formula errors.