ReferenceFunctionsEngineering Functions
DEC2OCT
DEC2OCT: Converts a decimal integer to octal text.
Summary
Optionally pads the result with leading zeros using places.
Remarks
numberis coerced to an integer and must be in[-2^29, 2^29 - 1].- Negative values are returned as 10-digit two's-complement octal strings.
placesmust be at least the output width and at most10, or#NUM!is returned.
Examples
Convert decimal to octal
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
100
Two's-complement negative output
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
7777777777
Related functions
FAQ
What range does DEC2OCT support?
number must be in [-2^29, 2^29 - 1]; outside that range returns #NUM!.
Runtime metadata
Category
Engineering
Signature
DEC2OCT(arg1: Number, arg2…: Number)Arity
min 1, max variadic
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
Caps
PURE
Source