How to Convert Text to Number in WPS on macOS

Use Convert Text to Number with 2 how-to topics in WPS Spreadsheets; all 2 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Use the Convert Text to Number button

Entry path: Data tab → Convert Text to Number

1. Select the cell range that contains numbers stored as text.
2. Confirm that the related cells show a green triangle warning in the upper-left corner.
3. Click Convert Text to Number in the Data tab.
4. Wait for WPS to convert the selected text numbers into numeric values in batches.
5. Check whether the green triangle warning has disappeared.

Success Criteria

• Visual result: The green triangle warning disappears from the selected range.
• What you can do next: The converted cells can be used in sums, sorting, and formulas.

Tips While Using

• Common mistake: If you do not select the target range first, the batch conversion may not apply to the intended cells.
• Environment note: In a collaborative sheet, keep a network connection if you want the result to sync promptly.

2. Convert from the green triangle warning

Entry path: Green triangle warning in the upper-left corner of a cell → Convert to Number / Batch Convert to Number

1. Click a cell that contains a number stored as text.
2. Confirm that a green triangle warning appears in the upper-left corner of the cell.
3. Open the drop-down menu next to the warning.
4. Select Convert to Number or Batch Convert to Number.
5. Check whether the text-formatted number has been converted into a numeric value.

Success Criteria

• Visual result: The green triangle warning disappears from the current cell or selected range.
• What you can do next: The converted data can participate in formulas and statistics normally.

Tips While Using

• Common mistake: Clicking the cell without opening the warning menu will not run the conversion command.
• Environment note: If the original content includes non-numeric characters, review the cell content before conversion.