Excel functions / Math
DEC2BIN function
Writes a whole number in binary.
Syntax
=DEC2BIN(number, [places])
Arguments
number: A whole number from -512 to 511.places(optional): Pad with zeros on the left to this many digits.
When to use it
DEC2BIN writes a whole number in binary (base 2), as text of 0s and 1s. A second argument pads it to a number of digits.
Examples
Ten in binary
A B C 1 Number 2 10 1010 In C2:
=DEC2BIN(A2)→ 1010Padded to eight digits
A B C 1 Number 2 10 00001010 In C2:
=DEC2BIN(A2, 8)→ 00001010
Common mistakes
- Large numbers. DEC2BIN takes numbers from -512 to 511. For larger ones, use BASE(A2, 2).
DEC2BIN in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: DEC2BIN
- Danish: DEC.TIL.BIN
- Dutch: DEC.N.BIN
- Finnish: DESBIN
- French: DECBIN
- German: DEZINBIN
- Hungarian: DEC.BIN
- Italian: DECIMALE.BINARIO
- Norwegian: DESTILBIN
- Polish: DZIES.NA.DWÓJK
- Portuguese (Brazil): DECABIN
- Portuguese (Portugal): DECABIN
- Russian: ДЕС.В.ДВ
- Spanish: DEC.A.BIN
- Swedish: DEC.TILL.BIN
- Turkish: DEC2BIN