BIN2DEC Function in ONLYOFFICE Spreadsheet Editor: Syntax, Examples and Troubleshooting

• Introduced: The original introduction version and date are not established by the official sources checked.
• Availability: Documented in the current ONLYOFFICE Spreadsheet Editor help; no final working-version endpoint is established.
• Scope: Docs and Desktop Editors release separately. This unversioned help does not establish availability in every older build, mobile client or deployment.
• Checked: October 14, 2026, against the official function reference. Documentation check; not a new native test.

Convert a binary numeral (base 2) to a decimal number (base 10), with each binary position representing a power of two. The formula is =BIN2DEC(number) according to the ONLYOFFICE BIN2DEC help article. All worked outputs below are mathematical expectations obtained independently; none is an observed result from a running copy of ONLYOFFICE.

Convert a binary numeral (base 2) to a decimal number (base 10), with each binary position representing a power of two. Each binary position is worth a power of 2, counted from the right (1, 2, 4, 8, 16, …). The official function reference categorizes BIN2DEC as an engineering function.

This is a base conversion, not a change to a worksheet’s number formatting. Keep original values alongside their converted equivalents so readers can audit the conversion. The expected results are decimal numbers (no fixed output width). Leading zeros in the input string are not preserved in the output.

=BIN2DEC(number)

The argument order is one required number argument. This function has no optional width argument. Exact source: ONLYOFFICE BIN2DEC function, checked 2026-10-13.

Use at most 9 characters in the nonnegative examples so the reference’s undocumented signed high-bit interpretation is not implicitly asserted. Decimal-base integers are not automatically binary or hexadecimal strings just because they contain digit characters. A quoted formula literal such as "1010" prevents loss of leading zeros in the expression; cell data may require Text formatting. Do not assume that text coercion, whitespace, lowercase input, signed encodings, or fractional inputs behave exactly like Excel or another editor.

1. Open a blank spreadsheet in the editor you plan to support and create headers A1 = Use case, B1 = Input, C1 = Formula / result. Treat these columns as a self-contained audit worksheet.
2. Enter all B2:B17 as Text before typing the values to prevent loss of leading zeros and to preserve any A–F digits.
3. Type the source values in column B exactly as shown. In C2, enter =BIN2DEC(B2), and then fill down through C17. Verify the function name using the editor’s Formula tab, Insert Function dialog or Shift+F3, as described in the official formula-entry guide.
4. Compare displayed values against the independent mathematical expectations below. Record the program edition, version, operating system and formula language if native results differ; this manuscript contains no native execution data.
5. Keep the unconverted column unchanged so that original inputs remain available for comparison.

Ready-to-paste formulas

The following use literal inputs rather than cell references. Quotes mark a base representation as text where applicable; the expected results are calculated independently using powers of the base.

Mathematical verification method: For conversion to decimal, evaluate the position weights in base 2 or 16. For conversion from decimal, repeatedly divide by the target base and read remainders from right to left (or equivalently compute the exact integer base representation). For text width, add leading zeros without changing the magnitude. These are not tests executed by ONLYOFFICE.

Decode an eight-character bit mask

In B2 store text 00101101. =BIN2DEC(B2) has independent expected result 45, because 32 + 8 + 4 + 1 = 45. Leading zeros do not change the positive mathematical value, but they are important if the code represents eight flags. This is not a claim about input coercion in a tested editor.

Round-trip and preserve width

For a binary identifier 00101101, =DEC2BIN(BIN2DEC("00101101")) independently yields 101101; leading zeros are lost in a minimal-width representation. Request an eight-character padded result with =DEC2BIN(BIN2DEC("00101101"),8), mathematically 00101101. The combined formula has not been run natively.

Separate numbers from identifiers

A value 00101 can represent the mathematical number 5 or a five-character fixed-width code. Store identifiers in Text-formatted cells, not as ordinary autoformatted numbers, to avoid losing zeros before applying the function. For reports, keep the original identifier in one column and the decoded numeric value in another.

Compare with general base conversion

=DECIMAL("101101",2) also has the mathematically expected result 45. DECIMAL has its own documented argument restrictions, so it is not proof that BIN2DEC accepts every long or signed string accepted by another function. Use the relevant official reference for each claim.

Do not infer undocumented limits. The official reference does not explain whether a 10-character binary value beginning with 1 is treated as signed. Signed two’s-complement behavior remains unverified in the intended ONLYOFFICE release. If a value is outside the clearly covered range, record it as needs native validation, not as a verified ONLYOFFICE output or an assumed error message. Invalid input can produce different errors depending on the case; this guide only attributes #NUM! to cases that the vendor explicitly documents.

• Current reference scope: The official English, unversioned ONLYOFFICE Spreadsheet Editor catalogue lists BIN2DEC. The Insert Function documentation explains both typing formulas and choosing them from the function wizard. This is documentation confirmation, not a runtime test.
• Web/Docs versions: The ONLYOFFICE Docs changelog lists Docs 10.0.0, released 2026-10-10. This is the release context checked on 2026-10-13; it does not prove BIN2DEC was introduced then, nor establish its first-supported version.
• Desktop versions: The distinct ONLYOFFICE Desktop Editors changelog lists Desktop 9.4.0, released 2026-05-19 at the time of research. Desktop and web deployment version numbers cannot be interchanged. This source does not establish this function’s first Desktop release.
• Historical releases and editions: No full historical execution matrix was available. Do not claim working support in older Docs/Desktop builds or specific editions without a vendor release note or directly recorded native test.
• Locale and syntax: The Advanced Settings instructions say formula language and regional settings are configurable. The function-entry guide uses English names and comma argument separators. Localized function names, decimal separators, accepted text coercions, and display formatting have not been checked in a live editor.
• Excel/Sheets/LibreOffice compatibility: This page makes no execution claim about those products. Their formats, sign rules, size limits and error behaviour cannot substitute for ONLYOFFICE verification.

Related ONLYOFFICE function documentation: DEC2BIN, BIN2HEX, HEX2DEC, BASE, DECIMAL. These vendor links were individually opened/checked on 2026-10-13.

For a base-independent representation, ONLYOFFICE documents BASE (number, radix, optional minimum length). For reading a text numeral in a specified radix, it documents DECIMAL (text, radix). These are related mathematical tools, not proof that their parameter limits or sign conventions equal those of BIN2DEC.

Verification limitations: Native execution in Desktop or Docs web, localized formula entry, quote/text coercion, signed boundaries and runtime error capture were not performed. Check these cases in the intended version before relying on them.