WPS Currency Field on Windows: Introduction

WPS Currency Field is a currency-formatted number field in smart tables for prices, reimbursements, budgets, and other financial records; 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 stated	The feature description shows no version restriction
Membership limit	None stated	The feature description shows no membership restriction

About This Feature

Overview

Currency Field is a special number field in smart tables that automatically displays entered values in a currency format and supports different currency symbols. It is suitable for product prices, reimbursement amounts, budget tracking, and other finance-related records.

Its main capabilities include:

Create a currency field for a table.
Change the currency symbol, such as CNY ¥ or USD $.
Set decimal places for consistent amount display.
Set a default value for newly added records.

Because it remains a number field, it can keep currency-style display while still fitting calculation and summary workflows.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	Local field settings usually do not require a constant connection; sign-in, sync, or online collaboration requires internet access
Other	You need access to a smart table and permission to edit fields

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation notes	Download and install the WPS Office client for Windows, then open a smart table to use related field features
Post-install check	Launch WPS Office, open a smart table, and confirm that the add-field entry is available on the right side of the header

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Currency Field in smart tables lets you create a dedicated field, switch currency symbols, set decimal places, and define a default value for new records.	Excel supports Currency and Accounting number formats, including symbol selection, decimal-place settings, and negative-number display options.	Google Sheets supports currency formatting and custom currency formats, with options for currency style and decimal places.	Notion database Number properties can be formatted as currency for price and amount tracking.	Acrobat form fields support number and currency formatting in PDF forms, but this is a PDF form workflow rather than a spreadsheet-style field workflow.
WPS Advantages	Advantage: WPS provides currency handling as a field type inside a table, with symbol, decimal, and default-value settings managed in one place. Distinct: This fits repeated data-entry workflows for financial records.	Compared with WPS: Excel focuses on cell formatting, and default values depend on how the worksheet is designed.	Compared with WPS: Google Sheets is centered on cell formatting rather than a dedicated field-type workflow with field-level default values.	Compared with WPS: Notion supports currency display in databases, but the official guidance focuses more on property formatting than on a broader field setup workflow.	Compared with WPS: Adobe is better aligned with PDF form entry than with structured table-field management.
Official Source	—	Format numbers as currency in Excel	Format numbers in a spreadsheet	Database properties	Format form fields in Acrobat

Overall Conclusion
WPS Currency Field is closer to a field-type workflow for structured table data, which is useful when you need to keep financial records consistent over time. Excel and Google Sheets emphasize cell formatting, while Notion and Adobe focus on database-property and PDF-form scenarios.

Use Cases

No.	Scenario	Suitable for	Main issue	How it helps
1	Product price management	E-commerce operators, sales teams	Price columns need a consistent currency symbol and display format	Create a currency field and choose the needed currency
2	Reimbursement tracking	Admin and finance teams	Amounts look inconsistent after entry and are harder to review	Set the currency symbol and decimal places
3	Budget ledger maintenance	Project managers, team leads	Re-entering common amounts for new records takes extra time	Set a default value for the currency field
4	Multi-currency records	Cross-border business teams	Amounts from different regions need clearer display differences	Switch the currency symbol in field settings
5	Financial calculations	Analysts and finance staff	Amounts need readable display and continued numeric use	Store values in a currency field and keep using them in calculations

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic use of Currency Field	✅ Available	✅ Available
Core Writer, Spreadsheet, and Presentation apps	✅ Available	✅ Available
Some advanced PDF and extended tools	Limited in some areas	✅ More advanced features available
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page; Why do I need to pay for WPS Office?

Recommendations

Usage scenario	Recommended plan	Why
You only need to create and maintain currency fields in smart tables	Free plan	This feature can be used without a membership restriction
You also need more PDF, template, or extended office features	WPS Premium	Suitable for users who need more advanced office tools and larger cloud storage

WPS membership center: Subscribe now
To compare plans and included benefits, open the subscription page and choose the option that fits your work.

Source: WPS Office pricing page