Excel functions / Math
BIN2DEC function
Turns a binary number into an ordinary one.
Syntax
=BIN2DEC(number)
Arguments
number: Up to ten 0s and 1s. Ten digits starting with 1 is a negative number.
When to use it
BIN2DEC reads a binary number (up to 10 digits of 0s and 1s) and gives it as an ordinary number.
Examples
Binary 1010
A B C 1 Binary 2 '1010 10 In C2:
=BIN2DEC(A2)→ 10Eight bits all set
A B C 1 Binary 2 '11111111 255 In C2:
=BIN2DEC(A2)→ 255
Common mistakes
- Long numbers. More than 10 digits gives #NUM!. DECIMAL(A2, 2) takes longer ones.
BIN2DEC 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: BIN2DEC
- Danish: BIN.TIL.DEC
- Dutch: BIN.N.DEC
- Finnish: BINDES
- French: BINDEC
- German: BININDEZ
- Hungarian: BIN.DEC
- Italian: BINARIO.DECIMALE
- Norwegian: BINTILDES
- Polish: DWÓJK.NA.DZIES
- Portuguese (Brazil): BINADEC
- Portuguese (Portugal): BINADEC
- Russian: ДВ.В.ДЕС
- Spanish: BIN.A.DEC
- Swedish: BIN.TILL.DEC
- Turkish: BIN2DEC