Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
BIN2DEC
BIN2DEC takes a text string representing a binary number (digits 0 and 1, up to 10 bits) and returns the equivalent decimal integer. It is useful when reading raw binary flags, bitmasks, or encoded data from embedded or network systems.
Excel
=BIN2DEC("1010")Google Sheets
=BIN2DEC("1010")✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Binary | Decimal |
| 0001 | =BIN2DEC("0001") |
| 1010 | =BIN2DEC("1010") |
| 1111 | =BIN2DEC("1111") |
| 11001 | =BIN2DEC("11001") |
=BIN2DEC("1010")→10
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Supply the binary number as a text string or cell reference containing only 0s and 1s (up to 10 digits).
- 2The function returns the decimal integer value (e.g., '1010' → 10).
- 3If the input exceeds 10 binary digits or contains invalid characters the function returns a #NUM! error.