NUMBERSTRING in WPS on Windows FAQ

Last updated:July 23, 2026

These FAQ entries focus on 3 common NUMBERSTRING topics: formula errors, nested usage, and automatic recalculation, followed by a glossary of key terms.

FAQ

How do I check a NUMBERSTRING error?

  1. Check whether the function name, brackets, and separators are entered correctly.
  2. Confirm that the referenced data contains numeric content that can be converted.
  3. If the formula is nested, test each layer step by step to find the part that causes the issue.

Can NUMBERSTRING be used with other functions?

  1. Test NUMBERSTRING by itself in a formula field first.
  2. Then use its result as an argument in another function.
  3. If the combined formula behaves unexpectedly, split the formula into smaller parts and check each part.

Does NUMBERSTRING recalculate automatically after data import?

  1. After the formula field is saved, the result updates when the data changes.
  2. If no result appears after import, first confirm that the formula was saved successfully.
  3. If the issue continues, check whether the imported field type matches the formula reference.

Glossary

TermDefinition
NUMBERSTRINGA formula function in multidimensional tables that converts numbers into uppercase or lowercase Chinese number text.
Formula fieldA field type that calculates results automatically from functions or expressions.
Parameter formatThe required structure of function input, including brackets, separators, and references.
Nested usageUsing the result of one function as the input of another function in the same formula.