WPS Currency Field on Windows: Introduction

Last updated:July 24, 2026

WPS Currency Field is a currency-formatted number field in Multi-Dimensional 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

MetricValueNotes
Core tasks4Matches the number of rows in the How-to Index
Available without membership4Matches the number of Free rows in the index
Membership-related items0Matches the number of membership-related rows in the index
Version limitNoneNo version gate is described for this feature
Membership limitNoneThe feature can be used directly

About This Feature

Overview

Currency Field is a special number field in Multi-Dimensional Tables. After you enter a value, the field displays it in a currency format, making it suitable for product prices, reimbursement amounts, budget values, and other financial data.

Its main capabilities include:

  • Create a currency field directly from the field type list.
  • Set a currency symbol such as RMB (¥) or USD ($).
  • Set decimal places for consistent amount display.
  • Set a default value for new records.

Because the field remains numeric, it works well in table workflows that need both currency display and numeric calculation.

System Requirements

ItemRequirement
Operating systemA Windows device that can run WPS Office normally
App versionThe latest version of WPS Office is recommended
NetworkNo mandatory network connection for local editing; network access is needed for sign-in or sync
OtherAccess to Multi-Dimensional Tables and permission to edit fields

Download & Installation

ItemDetails
Official downloadWPS Office Free Download
Installation notesDownload and install WPS Office for Windows, then open a Multi-Dimensional Table to use field-related features
Post-install checkOpen a Multi-Dimensional Table, click the + button on the header, and confirm that Currency appears in the field type list

Source: WPS download page

Compare with Alternatives

DimensionWPSMicrosoftGoogleNotionAdobe
Capability SummaryMulti-Dimensional Tables can create a Currency Field, set the currency symbol, decimal places, and default value, and display amounts in a currency format.Microsoft Lists and SharePoint lists support a Currency column for financial calculations and predefined currency formats.Google Sheets supports currency formatting for cells, including custom currency formats and decimal-place settings.Notion database Number properties can be formatted as currency, and new properties can be added with Add property or the + button.Adobe Acrobat form fields support Number and Currency formatting categories, but the feature is designed for PDF forms rather than table fields.
WPS AdvantagesAdvantage: WPS handles field creation, symbol selection, decimal-place settings, and default values directly at the table-field level, which fits structured amount entry.Compared with WPS: Microsoft focuses more on list column storage and formatting rules in list-based workflows.Compared with WPS: Google focuses more on cell formatting inside spreadsheets.Compared with WPS: Notion supports database property formatting, but the workflow is more database-oriented than table-field entry.Compared with WPS: Adobe mainly targets PDF form amount input instead of table or database field management.
Official SourceList and library column types and optionsFormat numbers in a spreadsheetDatabase propertiesFormat form fields in Acrobat

Overall Conclusion
WPS Currency Field is well suited to structured amount management in Multi-Dimensional Tables, especially when teams need consistent field formatting, default values, and later calculations. Other products also support currency display or amount input, but they focus more on list columns, spreadsheet cells, database properties, or PDF forms.

Use Cases

No.ScenarioSuitable ForMain Pain PointHow Currency Field Helps
1Product price managementSales and operations teamsPrices in one column are not displayed consistentlyUse a Currency Field to standardize amount display
2Reimbursement trackingAdmin and finance teamsIt is hard to identify the currency quickly after entrySet a fixed currency symbol for the field
3Budget trackingProject managers and team leadsDecimal precision is inconsistent across recordsSet uniform decimal places
4Faster record entryData entry staffRepeatedly entering common amounts takes timeSet a default value for new records
5Financial calculationsFinance and analysis teamsAmounts need to look like currency and still stay numericStore amount data in a currency-formatted numeric field

Membership & Benefits

Free vs WPS Premium

CapabilityFree UsersWPS Premium
Basic Writer, Spreadsheet, and Presentation components
Basic use of Currency Field
Some advanced PDF and extended featuresLimited or unavailable depending on the featureBroader access
Cloud storage and some value-added servicesBasic quotaHigher quota or more benefits

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

Recommendations

ScenarioRecommended PlanWhy
Daily price, reimbursement, or budget trackingFreeCurrency Field itself has no membership limit for basic setup and entry
Workflows that also need more PDF, cloud, or extended office featuresWPS PremiumA better fit when amount management is only one part of a broader office workflow

How to Subscribe

Source: WPS Office pricing page