NUMBERSTRING in WPS on Windows FAQ

Last updated:July 17, 2026

This FAQ covers 4 common questions about formula errors, parameter entry, and result checking when using NUMBERSTRING in WPS on Windows.

FAQ

What should I do if NUMBERSTRING shows an error after I enter it?

  1. Check whether the formula starts with =.
  2. Check whether the function name, parentheses, and separators are complete.
  3. Review the syntax guidance and confirm the parameter type and count.
  4. Press Enter again after making corrections.

How can I view the parameter instructions for NUMBERSTRING?

  1. Select the target cell and type =NUMBERSTRING(.
  2. Look at the syntax guidance that appears in the editing area.
  3. Complete the parameters based on the guidance and test the result.

Why is the NUMBERSTRING result not correct?

  1. Check whether the referenced cell is the correct data source.
  2. Confirm that the related number is not stored as text.
  3. If the formula includes other references, review them one by one.
  4. Recalculate and compare the result again.

Why does the result not change after I edit the source data?

  1. Confirm that the result cell actually references the data you changed.
  2. Check whether the formula has been replaced with a fixed value.
  3. Trigger recalculation and review the result again.
  4. Save and reopen the file if you need to confirm the linked update behavior.

Glossary

TermDefinition
NUMBERSTRINGA function name in WPS Spreadsheet used to convert numbers into Chinese number text.
Syntax guidanceThe on-screen parameter hint shown while entering a function.
Cell referenceA cell address used in a formula so the result can update when the source data changes.