Use Number Conversion with 2 task topics, both membership-related, and open the matching section from the How-to Index to complete each workflow.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Use Smart Toolbox for number conversion | WPS Premium required |
| 2 | 2. Convert cell number types | WPS Premium required |
How-to Guide
1. Use Smart Toolbox for number conversion
Entry: Member Exclusive tab → Smart Toolbox → Smart Toolbox panel → Format dropdown
- Select the cells that contain the numbers you want to convert.
- Click the Member Exclusive tab.
- Click Smart Toolbox.
- In the Smart Toolbox panel, click the Format dropdown.
- Choose the conversion type you need, such as letter case, rounding, keep values only, character superscript or subscript, text to formula, formula to text, replace Chinese punctuation with English punctuation, replace English punctuation with Chinese punctuation, number to text-formatted number, or text-formatted number to number.
Success Criteria
- Interface result: The selected cells are converted according to the rule you chose.
- What you can do next: You can continue editing, copying, saving, or applying other formatting tasks.
Tips While Using
- Some conversion items require membership and may not run until the related benefit is active.
- Before batch processing, test the result on a small sample range first.
2. Convert cell number types
Entry: Home tab → Convert dropdown
- Select the cells you want to change.
- On the Home tab, click the Convert dropdown.
- Choose the conversion type you need, such as number to text-formatted number, text-formatted number to number, text to hyperlink, keep values only, text to formula, formula to text, rounding, convert English letter case, convert Chinese and English punctuation, or convert character superscript and subscript.
Success Criteria
- Interface result: The cell type or displayed result changes as expected.
- What you can do next: The converted cells can continue to be used for calculation, display, or export.
Tips While Using
- Conversion items marked for membership require the related benefit.
- If the original data contains formulas or links, check the result again after conversion.