BIN2DEC in WPS Spreadsheet: Decode Binary Text and Signed Ten-Bit Values

=BIN2DEC(number)

The one required argument contains binary digits. WPS documents a maximum of ten bits, a sign bit followed by nine value bits, and two’s-complement representation for negative numbers. Use quoted strings in literal formulas so that leading zeros and digit count remain visible.

For a ten-character representation with leading 1, evaluate its unsigned binary value and subtract 1024. For example, 1111110110 has unsigned value 1014, so its signed value is 1014−1024=−10. A shorter positive string such as 101101 denotes 32+8+4+1=45; it is not a six-bit negative encoding.

The representational limits are −512 through 511. In particular, 1000000000 means −512, while 0111111111 means 511. This signed convention is not an arbitrary-length binary converter.

On a fresh worksheet, format A2:A5 as text before entering the following strings. Alternatively, use the quoted literal formulas in the last column to avoid dependence on data-entry formatting.

To convert the stored strings, put =BIN2DEC(A2) in B2 and copy the reference down. Verify the stored text before conversion: changing display formatting after a leading zero has already been lost does not restore the original representation.

The two forms of 45 show that leading zeros do not add numerical weight. They can nevertheless carry useful width information in an imported file. Keep the original text column alongside the converted numbers when that width matters.

The two error codes are explicitly stated by the official lesson. Blank inputs, surrounding whitespace, Boolean values, decimal fractions and numeric-string coercion beyond these explicit digit strings are not established here. Do not assume that the function strips a prefix such as 0b, accepts separators, or repairs damaged input.

A file supplies ten-bit signed deltas. Keep 1111110110 as text and decode it to −10. If the file specification separately defines one count as 0.25 units, multiplication by 0.25 gives a physical delta of −2.5 units. BIN2DEC supplies the signed count; it does not establish the scale or unit.

For a manual check, assign weights −512,256,128,64,32,16,8,4,2,1 to the ten positions. The active weights in 1111110110 sum to −10. This is an independent check of the encoding, not a second WPS execution.

If an external format instead defines an unsigned ten-bit quantity, 1111111111 should mean 1023 in that format, but BIN2DEC’s documented signed convention produces −1. Confirm the external format before choosing the conversion. Also keep decimal integers separate from written binary strings: the numeric value 45 and the character sequence 101101 represent the same magnitude in different notations.

The official WPS Academy BIN2DEC lesson, published 2019-06-24, is the product-specific source for this guide. It was reviewed on October 18, 2026. Its applicability field does not specify an edition, platform or numeric build. General platform links in the website footer do not establish applicability. The publication date establishes that the function was documented by that date; the first release and last supported version remain unknown. The cited lesson does not identify the function as deprecated or retired.

The examples are original, independently calculated expectations based on that documented contract. They were not executed in WPS, and no application screenshot is presented. Before exchanging a workbook, check the formula in the intended WPS edition and locale. These examples use the lesson’s English function names and comma separators; localized entry and file-format round trips have not been tested.

• DEC2BIN: create binary text from decimal values, with its own documented limits
• HEX2DEC: convert hexadecimal notation instead