WPS Number on iOS: Introduction

WPS Number is the numeric field type used in smart tables on iOS; this guide covers 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	All tasks in this guide are available directly

About This Feature

Overview

Number is the numeric field type in WPS Office smart tables on iOS. It is designed for storing and managing values such as amounts, quantities, and calculation results.

Core capabilities include:

Create a number field: set a column type to Number while editing the header.
Enter numeric values: type values directly in the record details panel.
Use number fields in formulas: numeric fields can be referenced in calculations.
Distinguish Number from Currency: use the right field type for plain values or money-related data.

On iOS, this feature is suited to quick entry and review. More detailed display adjustments such as decimal places or thousands separators are typically handled on desktop.

System Requirements

Item	Requirement
Operating system	An iPhone or iPad that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	Creating and entering number fields does not require a constant connection; keep a network connection for sync and collaboration scenarios
Other	Signing in is recommended for data sync and cross-device access

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Install WPS Office on your iPhone or iPad, then open a smart table to use number-field features
Check after installation	Open WPS Office, enter a smart table, and confirm that the Number field type is available in header editing

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In smart tables on iOS, WPS can create a Number field, enter numeric values, and use the field in formulas. The mobile workflow is focused on quick entry and review.	Excel supports applying number formats such as dates, currency, and fractions to worksheet cells, and it can also prevent unwanted automatic formatting by using Text format.	Google Sheets on iPhone and iPad supports formatting cells as numbers, dates, and currencies from the Cell > Number format menu.	Notion database Number properties accept numbers and can be formatted as currency or progress bars, and Formula properties can calculate from other properties.	Acrobat supports number formatting and calculations mainly in PDF form fields, which fits form workflows rather than spreadsheet-style field management.
WPS Advantages	Advantage: WPS uses a field-based workflow in smart tables, so numeric content is managed as a structured column type. Distinct: entering values through record details is convenient for lightweight mobile data tables.	Compared with WPS: Excel focuses on cell formatting in traditional spreadsheets rather than field-type management in a smart-table workflow.	Compared with WPS: Google Sheets on iOS emphasizes cell number formatting, so the workflow differs from field-type setup in a structured table.	Compared with WPS: Notion is closer to database property management and project organization than a standard spreadsheet-style numeric entry flow.	Compared with WPS: Acrobat is better aligned with PDF form input and calculated form fields, not with smart-table field creation and record entry.
Official Source	—	Format numbers in Excel	Format numbers in a spreadsheet	Database properties	PDF form fields and calculated values

Overall Conclusion: WPS Number is well suited to creating structured numeric fields and entering values quickly in smart tables on iOS. If your priority is traditional cell formatting, Excel or Google Sheets may be a closer fit. If your work centers on database properties or PDF forms, Notion and Adobe are better aligned with those specific workflows.

Use Cases

No.	Scenario	Suitable For	Main Need	How Number Helps
1	Expense tracking	Personal finance users	Amounts need to be entered and managed in one place	Create a number field to record income or expenses consistently
2	Inventory counts	Small teams	Quantity data is scattered and hard to update	Use a number field to maintain stock quantities
3	Project data collection	Collaborators	Values need to be reused in later calculations	Use number fields as inputs for formulas
4	Mobile inspection forms	Field staff	Numeric values must be entered quickly on a phone	Tap the number field in record details and enter the value
5	Separating values from money	Table maintainers	Plain numbers and monetary values should not be mixed	Use Number for general values and Currency for money-related fields

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Create and enter number fields	✅ Available	✅ Available
Basic smart table usage	✅ Available	✅ Available
Cloud storage	1 GB cloud storage	Higher cloud storage allowance
Templates and some advanced features	Limited	More advanced benefits available

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Daily lightweight records and simple calculations	Free	Number field creation and entry are enough for basic work
More cloud storage or long-term cross-device collaboration	WPS Premium	Better suited to ongoing sync, file management, and broader office needs

WPS membership center: Subscribe now