Spread WPF Documentation > Formula Reference > Formula Functions > HEX2OCT |
This function converts a hexadecimal number to an octal number.
HEX2OCT(number, places)
This function has these arguments:
Argument | Description |
---|---|
number | Hexadecimal numeric value to convert, must be between FFE0000000 and 1FFFFFFF |
places | [Optional] Number of characters to return; if not an integer, the number is truncated |
This functions returns an error when the number is not a valid hexadecimal number or if the value for places is non-numeric or negative. If places is omitted, the calculation uses the minimum number of characters necessary. This argument is useful for adding leading zeros to the result.
Accepts numeric data. Returns numeric data.
HEX2OCT("2B")