WPS Number Field on Windows: Introduction

Last updated:July 21, 2026

WPS Number Field is a numeric field type for Smart Table data tables; it includes 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

MetricValueNotes
Core tasks4Matches the number of rows in the How-to Index
Available without membership4Matches the number of Free rows in the index
Membership-related items0Matches the number of membership-related rows in the index
Version limitNoneThe feature description states no version limit

About This Feature

Overview

WPS Number Field is used to store and display numeric data in Smart Table data tables. It fits scenarios such as prices, quantities, percentages, and amounts that need to participate in calculations. This field supports creating a number field, setting number formats, setting a default value, and showing a thousands separator. Display formatting changes how values appear, but it does not change the stored value or calculation results.

System Requirements

ItemRequirement
Operating systemA Windows device that can run WPS Office normally
App versionIt is recommended to use the latest version of WPS Office
NetworkA stable network is recommended when opening online data tables or syncing team data
OtherYou need edit permission for the current data table to add fields and change field settings

Source: WPS Office tech specs

Download & Installation

ItemDetails
Official downloadWPS Office Free Download
Check after installationOpen WPS Office, then open a Smart Table data table and confirm that the add-field entry is visible on the right side of the header

Source: WPS download page

Compare with Alternatives

DimensionWPSMicrosoftGoogleNotionAdobe
Capability SummarySmart Table data tables support a Number Field for prices, quantities, percentages, amounts, and other numeric values, with options for number format, default value, and thousands separator.Microsoft Lists uses Number columns to store numeric values, and list columns can support sorting, filtering, calculations, and default values.Google Sheets lets users apply number, percentage, currency, and custom number formats to selected cells.Notion database Number properties accept numbers and can be formatted as currency or progress bars.Adobe Acrobat form fields support Number formatting for numeric display in PDF forms.
WPS AdvantagesDistinct: WPS brings format, default value, and thousands separator settings together in one field settings panel for direct data-table field management.Compared with WPS: Microsoft focuses on list column configuration and item forms rather than a single data-table field settings flow.Compared with WPS: Google focuses on cell-range formatting instead of centralized field-property settings for a data table.Compared with WPS: Notion supports number display formats, but the official help page does not present default-value setup in the same way.Compared with WPS: Adobe mainly targets PDF form field formatting rather than online data-table field management.
Official SourceMicrosoft Lists number columnsGoogle Sheets number formattingNotion database propertiesAdobe Acrobat field formatting

Overall Conclusion
WPS Number Field is a closer fit for online data-table field management because field creation and display rules are handled in one place. If your work is centered on spreadsheet cell formatting, list-column management, or PDF form processing, the other products also provide related capabilities, but their workflows and usage contexts are different.

Use Cases

No.ScenarioSuitable usersMain challengeHow Number Field helps
1Product price managementOperations and sales teamsPrice fields need consistent decimal and separator displayUse a Number Field and set the number format and thousands separator
2Inventory quantity trackingWarehouse and purchasing teamsQuantity entries need to stay numeric and easy to summarizeCreate a Number Field to record inventory quantities
3Percentage KPI trackingProject and analysis teamsPercentage values are displayed inconsistentlyStandardize the number format in field settings
4Auto-filled values for new recordsTeam collaboratorsInitial values are entered repeatedly for each new recordSet a default value for the Number Field
5Reading large amount valuesFinance and management usersLarge numbers are harder to scan quicklyTurn on the thousands separator for readability

Membership & Benefits

Free vs WPS Premium

CapabilityFree usersWPS Premium
Create a Number Field✅ Available✅ Available
Set number formats✅ Available✅ Available
Set default values and thousands separators✅ Available✅ Available
Other value-added servicesBasic plan features applyMore value-added services depend on the selected plan

Source: WPS Office pricing page

Recommendations

Usage scenarioRecommended planWhy
Daily data entry and basic field managementFree planThe Number Field tasks described here do not require membership
Teams that also need broader value-added servicesWPS PremiumA paid plan can be combined with other collaboration or value-added features based on the selected package

How to Subscribe

Source: WPS Office pricing page