NUMBERSTRING in WPS on Windows: Introduction

NUMBERSTRING in WPS on Windows is a formula for converting numbers into uppercase or lowercase Chinese number text in multidimensional tables; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

NUMBERSTRING is a formula function available in WPS multidimensional tables on Windows. It is used to convert numbers into uppercase or lowercase Chinese number text for amount display, receipt notes, and Chinese numeric labeling.

Core capabilities include:

Using NUMBERSTRING in a formula field inside a multidimensional table.
Entering parameters in the required function format and saving the calculation.
Combining NUMBERSTRING with other functions for more flexible field output.

This function is useful for finance records, Chinese amount display, and automated table presentation. It helps reduce repeated manual rewriting and keeps results updated when source data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	A network connection is needed for installation, sign-in, or online documents; local formula editing does not require a constant connection
Other	You need access to multidimensional tables and permission to add fields and edit formula fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, enter a multidimensional table, and confirm that you can add a Formula field and enter NUMBERSTRING

Source: WPS download center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	NUMBERSTRING converts numbers into uppercase or lowercase Chinese number text in multidimensional table formula fields and can be nested with other functions.	Excel text functions can format numbers as text, and Microsoft also documents number-to-text related functions such as BAHTTEXT in its text functions reference.	Google Sheets provides the TEXT function to convert a number into text according to a specified format.	Notion database formulas support number and text operations, including formatting values as text with functions such as format().	Adobe Acrobat focuses on PDF-to-Excel and related document conversion workflows rather than spreadsheet formula functions of the same type.
WPS Advantages	Advantage: It is directly oriented to Chinese number text output and works inside multidimensional table formula fields for automatic display updates.	Compared with WPS: Excel supports number-to-text formatting, but the official documentation does not describe the same Chinese number reading workflow in a spreadsheet formula field.	Compared with WPS: Google Sheets focuses on general text formatting patterns rather than a documented Chinese number reading function.	Compared with WPS: Notion formulas are designed for database properties, not a cell-based spreadsheet formula system.	Compared with WPS: Adobe centers on document conversion, not spreadsheet formula authoring.
Official Source	—	Excel text functions reference	Google Sheets TEXT function	Notion formula syntax	Adobe PDF to Excel

Overall Conclusion

If you need to display Chinese number text directly in a table workflow, NUMBERSTRING in WPS is more closely aligned with that use case. The other products mainly provide general text formatting, database formulas, or file conversion, so their documented workflows are not the same as this function.

Use Cases

No.	Scenario	Suitable for	Main challenge	How NUMBERSTRING helps
1	Chinese amount display	Finance and administrative staff	Numeric amounts need matching Chinese number text output	Use NUMBERSTRING in a formula field to generate Chinese amount text
2	Automatic table labeling	Data organizers	Rewriting Chinese number text manually takes time	Let the formula field calculate and display the result automatically
3	Combined formula output	Advanced table users	A single function may not cover a more complex display need	Nest NUMBERSTRING with other functions
4	Refresh after import	Record maintainers	Text results need to stay in sync after data changes	Formula field results refresh with source data updates
5	Receipt and note formatting	Users who need standardized number wording	Numeric values and Chinese wording need to stay consistent	Generate consistent Chinese number text with NUMBERSTRING

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
NUMBERSTRING function usage	✅ Available	✅ Available
Multidimensional table formula calculation	✅ Available	✅ Available
More advanced tools such as PDF conversion	Some features are limited	✅ More advanced capabilities are included
Cloud storage and multi-device benefits	Basic quota	Higher quota and more benefits

Source: WPS Office pricing page

Recommendations

Use case	Recommended plan	Why
You mainly need NUMBERSTRING in multidimensional tables	Free	The feature information shows no membership restriction for this function
You also need more PDF tools, cloud benefits, or broader office features	WPS Premium	Better suited for users who want expanded office capabilities and added benefits

WPS membership center: Subscribe now