WPS Currency Field on macOS: Introduction

WPS Currency Field is a DBSheet number field for recording and displaying amounts in currency format; 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	All topics in this guide are available directly

About This Feature

Overview

Currency Field is a special number field in WPS Office for macOS DBSheet. It formats values as currency and is designed for prices, reimbursements, budgets, and other amount-based records. After creating the field, you can set the currency symbol, decimal places, and a default value while keeping the field usable in calculations.

Core tasks include:

Create a currency field for price and finance-related records.
Change the currency symbol for different currencies such as RMB or USD.
Set decimal places for consistent amount display.
Set a default value for faster data entry in new records.

System Requirements

Item	Requirement
Operating system	A macOS device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory network is required for local editing; sign-in, sync, and online collaboration require a network connection
Other	You need to open a DBSheet and have permission to edit fields

Download & Installation

Before using Currency Field, install WPS Office for Mac and open a DBSheet.

Item	Details
Official Download	WPS Office Free Download
Post-install Check	Launch WPS Office, open a DBSheet, and confirm that the add-field entry is visible on the right side of the table header

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In DBSheet, you can create a field as a currency type directly and set its currency symbol, decimal places, and default value for ongoing amount records.	Excel lets users format cells as Currency or Accounting and choose the currency symbol and decimal places.	Google Sheets lets users apply currency formatting to cells and supports custom currency and decimal display.	Notion database Number properties can be formatted as currency for price-style records in databases.	Acrobat focuses on PDF forms and PDF editing. Its official help covers form field properties rather than spreadsheet-style currency field management.
WPS Advantages	Advantage: WPS manages an entire amount column as a field type instead of only formatting individual cells. Distinct: it combines default value setup, display formatting, and calculation-ready numeric storage in one field setting flow.	Compared with WPS: Excel mainly focuses on cell formatting, so field-level default value management depends on how the sheet is designed.	Compared with WPS: Google Sheets mainly applies formatting to selected cells or ranges, with less field-structured management.	Compared with WPS: Notion is closer to database property display than a traditional spreadsheet cell workflow.	Compared with WPS: Adobe's official workflow centers on PDF forms and document handling rather than DBSheet amount fields.
Official Source	—	Excel currency formatting	Google Sheets number and currency formatting	Notion database properties	Acrobat form field properties

Overall Conclusion: If you need to maintain one amount column over time and want field type, display format, and default entry behavior managed in one place, WPS Currency Field fits that workflow well. Other products also support money display, but their official workflows focus more on cell formatting, database properties, or PDF forms.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Product price management	E-commerce teams, store managers	Price fields need a consistent currency display	Create a Currency Field and set the required currency symbol
2	Reimbursement tracking	Admin teams, finance teams	Amount entry formats are inconsistent	Set unified decimal places for all amount values
3	Project budget tracking	Project managers, team leads	New records repeatedly need the same starting amount	Set a default value for the Currency Field
4	Multi-currency data organization	Cross-border teams, procurement teams	Different currencies are hard to distinguish	Switch the currency symbol in field settings
5	Formula-based reports	Finance analysts, business analysts	Amounts need to display as currency and still be calculated	Store values in a Currency Field and continue using them in formulas

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Premium
Core Writer, Spreadsheet, and Presentation apps	✅ Available	✅ Available
Basic use of Currency Field	✅ Available	✅ Available
Some advanced PDF and extended tools	Partial access or limits apply	✅ More features available
Cloud storage and some value-added capabilities	Basic quota	Higher quota or more benefits

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Daily price, budget, and reimbursement records	Free	Currency Field itself has no membership restriction for the tasks covered in this guide
Users who also need more PDF, cloud, or extended office capabilities	WPS Premium	Better suited to broader office workflows beyond basic amount field setup

WPS membership center: Subscribe now