ReferenceFunctionsEngineering Functions
OCT2HEX
OCT2HEX: Converts an octal text value to hexadecimal text.
Summary
Supports optional left-padding through the places argument.
Remarks
- Input must be octal text up to 10 digits and may be signed two's-complement.
- Signed values are converted through their decimal representation.
placesmust be at least the output width and at most10, or#NUM!is returned.
Examples
Convert octal to hex
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
3F
Convert signed octal
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
FFFFFFFFFF
Related functions
FAQ
How does OCT2HEX treat signed octal input?
Signed 10-digit octal is decoded via two's-complement and then emitted as hex, preserving signed meaning.
Runtime metadata
Category
Engineering
Signature
OCT2HEX(arg1: Number, arg2…: Number)Arity
min 1, max variadic
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
Caps
PURE
Source