WPS Number Field on macOS: Introduction

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

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Version limit	None	Number Field entry points are available directly

About This Feature

Overview

WPS Number Field is used to store and display numeric data in smart table data tables on macOS. It works well for prices, quantities, percentages, amounts, and other values that may be used in calculations.

Core tasks include:

Create a number field to add a new numeric column.
Set the number format to show integers or 1 to 9 decimal places.
Set a default value for newly added records.
Show the thousands separator to improve readability for large numbers.

This feature is useful for product management, expense tracking, inventory records, and progress data. Display formatting affects how values appear, while the stored value remains available for later calculation and review.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for Mac
Network	Local field settings usually do not require a network connection; sign-in, sync, and collaboration features work better with network access
Other	You need access to a smart table data table and permission to edit its fields

Source: System requirements for WPS Office

Download & Installation

Before using Number Field, install WPS Office on your Mac and open a smart table data table.

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, enter a smart table data table, and confirm that field creation and field settings are available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Number Field can store prices, quantities, percentages, amounts, and other numeric values in a data table, with support for integer display, decimal places, default values, and thousands separators.	Microsoft Forms supports numeric restrictions for text responses, such as greater than, less than, or between conditions, but it is mainly designed for form collection rather than data-table field setup.	Google Forms supports response validation for short-answer questions, including number-only input, range limits, and comparison rules.	Notion database Number properties accept numbers and can be formatted as currency or progress bars for database records.	Adobe Acrobat Sign text fields can use validation types such as Number, Currency, and Percent, mainly for form input validation.
WPS Advantages	Distinct: WPS focuses on data-table field management and combines default values, display formatting, and thousands separators in one field setup flow.	Compared with WPS: Microsoft Forms focuses more on validating submitted form input than on managing a reusable data-table column.	Compared with WPS: Google Forms focuses on submission rules for form answers instead of long-term field management in a data table.	Compared with WPS: Notion supports numeric database properties, but the official description here focuses more on property type and display options.	Compared with WPS: Adobe focuses on validation in signing or online form scenarios rather than data-table column configuration.
Official Source	—	Adjust your form or quiz settings in Microsoft Forms	How to set rules for your form	Database properties	Form field validations

Overall Conclusion
If your main goal is to manage numeric columns in a data table over time and keep display rules consistent, WPS Number Field is a closer fit for structured table management. Other products also support number-related capabilities, but they are more focused on form validation or general database property settings.

Use Cases

No.	Scenario	Suitable for	Main challenge	How Number Field helps
1	Product price management	E-commerce teams and store managers	Price columns need consistent numeric input and calculation-ready values	Create a number field and set suitable decimal places
2	Inventory quantity tracking	Warehouse and purchasing teams	Quantity values should stay in integer format	Set the number format to integer
3	Default budget entry	Finance teams and project owners	New records often start with the same initial value	Set a default value for the number field
4	Large-number display	Managers and analysts	Long numbers are hard to scan quickly	Turn on the thousands separator
5	Percentage display	Operations and data analysts	Ratio values need a consistent display style	Store values in a number field and manage the display format

Membership & Benefits

Free vs WPS Premium

Number Field itself is not membership-restricted and can be used directly in smart table data tables. If you also need broader office features, you can choose between the free plan and a paid plan based on your overall workflow.

Capability	Free users	WPS Premium
Basic use of Number Field in smart table data tables	✅ Available	✅ Available
Core Writer, Spreadsheet, and Presentation components	✅ Available	✅ Available
Some advanced PDF and extended office features	Basic access as shown on product pages	More extended capabilities
Cloud storage	1 GB	20 GB shown on the pricing page

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You only need to create and manage number fields in data tables	Free	Number Field is available without membership and covers basic entry and formatting needs
You also need more cloud storage or broader office features	WPS Premium	A better fit for users who need more storage, cross-component workflows, or additional advanced features

WPS membership center: Subscribe now