HEX2OCT

Summary

Supports optional left-padding through the places argument.

Input must be hexadecimal text up to 10 characters and may be signed two's-complement.
Converted values must fit the octal range [-2^29, 2^29 - 1], or #NUM! is returned.
places must be at least the output width and at most 10, or #NUM! is returned.

Convert hex to octal

Grid

Cell	Value
No inputs on Sheet1.

Formula

Result

Not evaluated yet.

Expected

Convert signed hex

Grid

Cell	Value
No inputs on Sheet1.

Formula

Result

Not evaluated yet.

Expected

7777777777

The decoded value must fit octal output range [-2^29, 2^29 - 1], and optional places must be valid.