How to Use WPS Percentage Field on macOS

Last updated:July 22, 2026

This how-to guide includes 2 topics, covering creating a percentage field and configuring field properties; 2 topics are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Create a Percentage FieldFree
22. Configure Field PropertiesFree

How-to Guide

1. Create a Percentage Field

Entry: Click the + button on the table header and choose the Percentage field type

  1. In the data table, click the Add Field button on the right side of the header.
  2. In the field type list, select Percentage.
  3. Enter a field name.
  4. Click Confirm to create the field.
  5. Enter data in the new field cells using the appropriate input method.

Success Criteria

  • Interface result: A new percentage field column appears in the table.
  • What you can do next: You can enter and edit data in the new field cells.
  • No side effect: Existing fields and records remain unchanged.

Tips While Using

  • Common mistake: Choosing a different field type changes how the values are displayed.
  • Data check: After creation, enter a sample value to confirm that the display matches your needs.

2. Configure Field Properties

Entry: Right-click the field > Field Settings > Number Format

  1. Right-click the existing percentage field.
  2. Select Field Settings.
  3. Open the Number Format drop-down menu in the settings panel.
  4. Adjust the display format for percentage values as needed.
  5. Click OK to save the changes.

Success Criteria

  • Interface result: The display style of percentage values is updated.
  • What you can do next: Future entries in the field follow the current format.
  • No side effect: The field name and existing record content are not removed.

Tips While Using

  • Common mistake: If you do not click OK, the changes may not be saved.
  • Data check: Review existing records after the change to confirm that the display precision is appropriate.