DEC2OCT

Description Converts a decimal number (base 10) to an octal number (base 8).

Syntax DEC2OCT ( integer [, places])

Argument Description

integer Any negative or positive whole number or zero. For the purposes of this function, the integer entered must be small enough to convert within the limits of the target. Any integer between -536,870,912 to 536,870,911 may be used.

places Optional number of characters to use in the output. If places is omitted, the function returns the number of spaces required to display the result. The places argument can be used to 0-pad a positive number.If the number is negative, places is ignored and 10 characters are returned.

Argument	Description
integer	Any negative or positive whole number or zero. For the purposes of this function, the integer entered must be small enough to convert within the limits of the target. Any integer between -536,870,912 to 536,870,911 may be used.
places	Optional number of characters to use in the output. If places is omitted, the function returns the number of spaces required to display the result. The places argument can be used to 0-pad a positive number.If the number is negative, places is ignored and 10 characters are returned.

Remarks Note that the result of this function is a text string.

Examples This function returns 144:

DEC2OCT(100)

This function returns 7777777634:

DEC2OCT(-100)

This function returns 007:

DEC2OCT(7,3)