How to Use the NUMBERSTRING Function in WPS on Windows

Last updated:July 23, 2026

This how-to guide includes 3 topics for NUMBERSTRING, covering formula field creation, parameter format review, and example verification; all 3 topics are available without membership.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call NUMBERSTRINGFree
22. Review the parameter formatFree
33. Write and verify an exampleFree

How-to Guide

1. Create a formula field and call NUMBERSTRING

Entry path: Add Field → Formula

  1. Open the multidimensional table that you want to edit.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Enter a formula that includes NUMBERSTRING in the formula editor.
  5. Click Confirm to save and check whether the field result appears immediately.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • Next action available: You can continue editing the formula or reviewing the calculated result.
  • No side effect: Existing source fields are not directly overwritten.

Tips While Using

  • Common mistake: If you choose a plain text field instead of a formula field, the calculation will not run.
  • Environment note: You need permission to edit fields in the current multidimensional table.

2. Review the parameter format

Entry path: Formula Editor → Function Library → NUMBERSTRING

  1. Open the formula editor in the multidimensional table.
  2. Go to the function library and find NUMBERSTRING.
  3. Review the function parameter format.
  4. Fill in the parameters according to the format shown in the editor.
  5. Return to the formula input area and check that brackets, separators, and references are complete.

Success Criteria

  • Interface result: You can see the NUMBERSTRING function name and its parameter format.
  • Next action available: You can continue entering the full formula based on the displayed format.

Tips While Using

  • Common mistake: Missing brackets or incomplete separators can cause formula errors.
  • Environment note: Different field types can affect how references are used in the formula.

3. Write and verify an example

Entry path: Formula Field → Edit Formula

  1. Enter =NUMBERSTRING(target range) or the corresponding field reference in the formula field.
  2. Confirm that the referenced data contains numeric content that can be converted.
  3. Save the formula and review the result.
  4. Change the source data and check whether the formula field updates at the same time.
  5. Combine NUMBERSTRING with other functions when needed.

Success Criteria

  • Interface result: The formula field shows the converted text result.
  • Next action available: After source data changes, the result updates automatically.

Tips While Using

  • Common mistake: Referencing incompatible content can return an error.
  • Environment note: When nesting other functions, confirm that the outer function is compatible with text output.