How to Use WPS Number Conversion on macOS

Use Number Conversion through 6 how-to topics, including 3 free tasks and 3 membership-related items; choose a topic from the index and follow the menu path and steps below.

How-to Index

How-to Guide

1. Convert numbers to text-formatted numbers or convert text-formatted numbers to numbers

Feature entry: Home tab → Convert drop-down menu

1. Select the cells you want to process.
2. Click the Convert drop-down menu on the Home tab.
3. Select Number to Text-formatted Number or Text-formatted Number to Number.
4. Check whether the cells now use the target data type.

Success Criteria

• The cell values stay the same, but the stored data type changes.
• The result can be used for later calculation, sorting, or text processing.

Tips While Using

• If a cell contains mixed characters, the result may depend on the original content.
• Confirm the selected range before running the conversion.

2. Convert text to a hyperlink

Feature entry: Home tab → Convert drop-down menu

1. Select the cells that contain URLs or link text.
2. Open the Convert drop-down menu.
3. Select Text to Hyperlink.
4. Click the result cell to confirm that the link opens correctly.

Success Criteria

• The text in the cell becomes a clickable hyperlink.
• Clicking the cell opens the related webpage or address.

Tips While Using

• Make sure the original text is a complete and valid link address.
• If the text is not in a standard link format, adjust it before conversion.

3. Convert Chinese and English punctuation or change English letter case

Feature entry: Home tab → Convert drop-down menu

1. Select the text cells that need consistent formatting.
2. Click the Convert drop-down menu.
3. Select Convert Chinese and English Punctuation or Change English Letter Case as needed.
4. Review the converted text to confirm the formatting result.

Success Criteria

• Punctuation or English letter case is standardized in the selected cells.
• The content is ready for later editing, export, or display.

Tips While Using

• Test a small sample first before processing a large range.
• For text with special characters, keep a backup copy before conversion.

4. Keep values only

Feature entry: Membership tab → Smart Toolbox → Format drop-down menu

1. Select the cells that contain formula results.
2. Click the Membership tab.
3. Open Smart Toolbox, then open the Format drop-down menu.
4. Select Keep Values Only.
5. Check whether the cells now keep only the displayed result values.

Success Criteria

• The cells keep the current result values.
• The original formulas no longer update with linked calculations.

Tips While Using

• This feature requires WPS Premium.
• After conversion, the original formulas are replaced by result values, so backing up data first is recommended.

5. Convert between text and formulas

Feature entry: Home tab → Convert drop-down menu, or Membership tab → Smart Toolbox → Format drop-down menu

1. Select the target cells.
2. Open the related conversion entry.
3. Select Text to Formula or Formula to Text.
4. Confirm that the cells now display the target form.

Success Criteria

• Text can be recognized as a formula, or a formula can be shown as text.
• The result is easier to review, copy, or adjust.

Tips While Using

• Text to Formula and Formula to Text are membership-related features.
• Before conversion, confirm that the text follows valid formula syntax.

6. Round numbers

Feature entry: Home tab → Convert drop-down menu, or Membership tab → Smart Toolbox → Format drop-down menu

1. Select the decimal values you want to process.
2. Open the related conversion menu.
3. Select Round.
4. Check whether the result matches the required precision.

Success Criteria

• The values are rounded according to the selected rule.
• The worksheet is easier to present and summarize.

Tips While Using

• This feature requires WPS Premium.
• Confirm the required precision before applying the conversion to a large range.