Converts a decimal number to binary.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
DEC2BIN(number, [places])The DEC2BIN function takes a decimal integer and returns its binary equivalent as a text string. If the number is negative, the function returns a 10-character two's complement binary number.
=DEC2BIN(10)Ergebnis: 1010
Converts the decimal number 10 to its binary representation.
=DEC2BIN(5, 8)Ergebnis: 00000101
Converts 5 to binary with a fixed length of 8 characters.
The function supports decimal integers from -512 to 511.