How to Use WPS Currency in Spreadsheet on Android

Last updated:July 24, 2026

Use WPS Currency in Spreadsheet on Android with 3 how-to topics: create a currency field, enter amounts, and view amount display and summaries.

How-to Index

No.TopicMembership Requirement
11. Create a currency fieldFree
22. Enter amountsFree
33. View amount display and summariesFree

How-to Guide

1. Create a currency field

Entry path: Tap the header → Edit → Field Type → Currency

  1. Tap the header that you want to configure.
  2. In the floating toolbar, tap Edit.
  3. In the field editing window, tap Field Type.
  4. Select Currency.
  5. Set the field name and confirm to finish creating the currency field.

Success Criteria

  • On-screen result: the field type is shown as Currency.
  • What you can do next: you can continue entering amount data in this field.

Tips While Using

  • Common mistake: you cannot change the field type before opening the field editing window.
  • Environment note: the current data table must support field editing.

2. Enter amounts

Entry path: Tap the target cell → Open record details → Select the currency field

  1. Tap the target cell to open record details.
  2. Tap the related currency field.
  3. Enter the amount.
  4. Return to record details or the data table to review the result.

Success Criteria

  • On-screen result: the entered amount appears in the currency field.
  • What you can do next: you can continue editing other records or fields.

Tips While Using

  • Common mistake: entering an amount in a non-currency field may not show a currency-style display.
  • Environment note: you need edit permission for the current record.

3. View amount display and summaries

Entry path: Open a data table or related summary view that already contains a currency field

  1. Open a data table that already includes a currency field.
  2. Check how the amounts are displayed in the field.
  3. In a summary scenario, review totals, averages, or other summary results.
  4. Confirm that the results are shown in the related currency style.

Success Criteria

  • On-screen result: amounts are displayed in a currency style and summary results can be viewed normally.
  • What you can do next: you can continue filtering, editing, or adding amount records.

Tips While Using

  • Common mistake: treating a regular number field as a currency field can lead to a different display style.
  • Environment note: some currency symbol changes may need to be completed on desktop first.