Scripting Formulas Legacy


LEGACY.BIN2OCT(value, places = 0)

Converts a binary-formatted value to octal format. LEGACY.BIN2OCT is compatible with the BIN2OCT formula function used in many spreadsheet programs, and value is limited to 10 characters. The first character is the sign bit.

The optional places parameter defines the number of characters to use, padding the return value with loading zeroes if it's shorter.