DEC2OCT

Converts the specified decimal number to its octal (base 8) equivalent.

Syntax

BIN2OCT( NumberOrText x, [Integer digits] ) → Text

Parameters

x

Required. The decimal number to convert, expressed as either text or number.

digits

Optional. The number of characters to use for the result, useful for padding the return value with leading zeros.

Remarks

If x is less than -2^29 or greater than 2^29-1, the function returns the #NUM! error value. If x is non-numeric, the function returns the #VALUE! error value.

If digits is omitted, the function uses the minimum number of characters necessary. If digits is specified and is less than the number of characters required to represent the result, the function returns the #NUM! error value. If digits is negative or greater than 10, the return value is #NUM!. If digits is not an integer number, it is truncated.

Example

Formula

=DEC2OCT(11,4)
=DEC2OCT(-10)

See Also

Function Reference
BIN2DEC Function
HEX2DEC Function
OCT2DEC Function