OCT2BIN

Description Converts an octal number (base 8) to a binary number (base 2).

Syntax OCT2BIN( 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 0 and 777 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 0 and 777 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 1000:

OCT2BIN(10)

This function returns 111111111:

OCT2BIN(777)