WPS Percentage in Spreadsheet on Android FAQ

Last updated:July 24, 2026

When using Percentage in Spreadsheet, the 3 most common question types are field setup, value display, and summary results; this FAQ covers 3 frequent questions.

FAQ

If I enter 50, will it display as 50% or 0.5%?

  1. Tap the target cell in the percentage field.
  2. Enter 50 and finish the input.
  3. Check the result. The value is displayed as 50%.

Can a percentage field be used in summary calculations?

  1. Enter multiple values in the percentage field.
  2. Open or view the statistics area in the current table.
  3. Check summary results such as sum and average.

Why is the percent sign not displayed after I enter a value?

  1. Check whether the current column is already set as a percentage field.
  2. If not, return to header editing and change the field type to Percentage.
  3. Enter the value again and review the result.

Glossary

TermDefinition
Percentage fieldA field type that displays values as percentages and is suitable for ratios, completion rates, and shares.
Summary statisticsResults such as sum and average that are calculated from data in a field.
Field typeA setting that defines how a column stores and displays data, such as percentage, text, or number.