BIN2OCT

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

Syntax BIN2OCT ( binary_number [, places])

Argument Description

binary_number Any number expressed in the binary number system (represented by the digits 1 or 0).Data may be entered in text or numerical form. A maximum of 9 value bits (or digits) is allowed in representing positive values. To represent negative values, enter exactly 10 digits--the first digit must be a 1. Positive values may be zero-padded on the left up to a maximum of 10 digits.

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
binary_number	Any number expressed in the binary number system (represented by the digits 1 or 0).Data may be entered in text or numerical form. A maximum of 9 value bits (or digits) is allowed in representing positive values. To represent negative values, enter exactly 10 digits--the first digit must be a 1. Positive values may be zero-padded on the left up to a maximum of 10 digits.
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 164:

BIN2OCT(1110100)

This function returns 00777:

BIN2OCT(111111111,5)