How to Use WPS Number Format on macOS

Use WPS Number Format through 8 how-to topics, including ribbon-based formatting, right-click formatting, custom formats, and quick style controls; 7 topics are available without membership and 1 is membership-related.

How-to Index

How-to Guide

1. Set a number format from the ribbon

Entry point: Home tab → Number Format drop-down

1. Select the cell or range that you want to format.
2. Click the Number Format drop-down on the Home tab.
3. Select the format you need, such as General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, or Text.

Success Criteria

• The selected cells display values in the chosen format.
• You can continue editing, copying, or saving the worksheet normally.

Tips While Using

• Number formatting usually changes how a value is displayed rather than the underlying value itself.
• Date, time, and percentage results depend on the original cell content.

2. Set a number format from the right-click menu

Entry point: Right-click menu → Format Cells → Number tab

1. Select the target cell and right-click it.
2. Click Format Cells.
3. In the dialog box, switch to the Number tab.
4. Select the format category you need and confirm the setting.

Success Criteria

• The selected format is applied to the target cells.
• You can continue adjusting other cell-format settings in the same dialog box.

Tips While Using

• This path is useful when you want to review several formatting settings in one place.
• If multiple cells are selected, confirm that their data types are suitable for the same format.

3. Create a custom number format

Entry point: Right-click menu → Format Cells → Number tab → Custom

1. Select the target cell and open Format Cells.
2. Switch to the Number tab.
3. Select Custom.
4. Enter the format code you want to use.
5. Click OK to apply it.

Success Criteria

• The cell displays content according to the custom rule you entered.
• The custom format is active for the selected cell.

Tips While Using

• Membership note: this item is marked as membership-related in the feature description, and actual availability depends on what appears in the app.
• Before entering a format code, confirm the display result you want, such as decimal places, prefixes, suffixes, or section rules.

4. Apply a currency symbol quickly

Entry point: Home tab → drop-down next to the currency symbol button

1. Select the cells you want to format.
2. Click the drop-down next to the currency symbol button.
3. Select the currency symbol you want.

Success Criteria

• The selected cells display the chosen currency symbol.
• The amount display is more suitable for finance or quotation scenarios.

Tips While Using

• Currency symbols are usually clearer when combined with a numeric format.

5. Apply percentage style quickly

Entry point: Home tab → Percentage Style button

1. Select the cells you want to format.
2. Click the Percentage Style button on the Home tab.

Success Criteria

• The selected cells display values as percentages.
• You can continue adjusting precision with decimal-place controls.

Tips While Using

• Different original values produce different percentage results after formatting.

6. Apply the thousands separator quickly

Entry point: Home tab → Thousands Separator Style button

1. Select the cells you want to format.
2. Click the Thousands Separator Style button on the Home tab.

Success Criteria

• Large numbers display with thousands separators.
• Values are easier to scan and verify.

Tips While Using

• This style is useful for amounts, sales figures, inventory counts, and other large numbers.

7. Increase decimal places quickly

Entry point: Home tab → Increase Decimal button

1. Select the cells you want to format.
2. Click the Increase Decimal button.

Success Criteria

• More decimal places are shown in the selected cells.
• Finer numeric precision is visible in the worksheet.

Tips While Using

• After increasing decimal places, you may need to widen the column for better display.

8. Decrease decimal places quickly

Entry point: Home tab → Decrease Decimal button

1. Select the cells you want to format.
2. Click the Decrease Decimal button.

Success Criteria

• Fewer decimal places are shown in the selected cells.
• The worksheet looks cleaner and more compact.

Tips While Using

• After reducing visible decimals, review whether the display still matches your reporting needs.