BASE in WPS Spreadsheet: Convert Decimal Integers to Padded Base Text

The official WPS Windows pages, checked October 19, 2026, document this function and advertise ordinary entry and calculation without membership. Their last-updated date is 2026-07-07; that is a documentation date, not its introduction release. They do not name an exact minimum or last supported build. Availability on Mac, Linux, mobile, web or historical builds is not established here.

The BASE examples below are independently calculated exact text strings. They were not executed in WPS, and no native screenshot is claimed. Before relying on an installation, check its function prompt and run a small control example.

=BASE(number, radix, [min_length])

number is the required decimal value to convert. radix is the required target base. [min_length] is optional and specifies a minimum text width, with leading zeros added when needed. Square brackets mark an optional argument; do not type them in a formula. The examples use small nonnegative integers and binary or hexadecimal bases.

The documented Windows workflow supports typing the formula in a cell or choosing the function through Formula → Insert Function. These formulas use English names and comma separators. Inspect the destination formula after filling down so that relative references and fixed settings still point to the intended cells.

Put 10, 13 and 42 in A2:A4. In B2 enter =BASE(A2,2,6) and fill down. The expected text strings are 001010, 001101 and 101010. These are suitable for a teaching worksheet or a small fixed-width status-code export where the receiving system expects binary text.

For reusable settings, put radix 2 in E1 and width 6 in F1. Fill =BASE(A2,$E$1,$F$1) down B2:B4. The dollar signs keep the shared conversion settings fixed while A2 changes to A3 and A4.

Use =BASE(31,16,4) to obtain expected text 001F, and =BASE(255,16,4) for 00FF. Decimal 31 equals 1×16+15, so its hexadecimal digits are 1 and F. The leading zeros supply the requested width; they do not change the represented quantity.

Keep the original decimal column if downstream arithmetic is required. The converted output is text, and identifiers containing letters or meaningful leading zeros should not be treated as ordinary decimal amounts.

For the binary result 001010, independently reconstruct the integer as 0×32+0×16+1×8+0×4+1×2+0=10. For 101010, the same positional weights give 32+8+2=42. This is an independent place-value check that does not rely on another conversion function.

A minimum width is not a truncation instruction. =BASE(42,2,4) has expected text 101010, because six digits are needed to represent 42. Compare it with the six-character case above before designing an export schema with a maximum-width requirement. Separately validate the largest permitted source value for your schema.

• A binary-looking result such as 101010 is text representing 42 here, not the decimal number one hundred one thousand and ten.
• Check argument order before changing formatting: radix chooses the number system, while min_length controls minimum output width.
• WPS’s FAQ recommends numeric arguments and checking spaces or unexpected text for #VALUE!; this is not a complete error specification.
• The reviewed documentation does not establish WPS’s maximum radix, maximum number, width limit, treatment of fractional or negative inputs, or an exact omitted-width default. Do not import another spreadsheet’s limits. These examples always state a width and avoid those boundaries.

DEC2BIN, DEC2HEX.

• WPS BASE: introduction and availability
• WPS BASE: syntax and entry
• WPS BASE: troubleshooting