How to Use WPS Number Format on Windows

This how-to guide includes 8 topics, covering ribbon-based formatting, right-click formatting, custom formats, and quick style controls; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Set Number Format from the Ribbon

Feature entry: Home tab → Number Format drop-down menu

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

Success Criteria

• The selected cells display content in the chosen format.
• You can continue editing, copying, or saving the spreadsheet.

Tips While Using

• Number formatting changes the display style, not the underlying value.
• If the original content is stored as text, some number formats may not behave as expected in calculations.

2. Set Number Format from the Right-Click Menu

Feature entry: Right-click menu → Format Cells → Number tab

1. Select the target cells and right-click.
2. Select Format Cells.
3. In the dialog box, open the Number tab.
4. Select the category you want and confirm the change.

Success Criteria

• The selected category in the Format Cells window is applied to the target cells.
• The cell display matches the selected category.

Tips While Using

• This entry is useful when you need more detailed formatting settings.
• To standardize multiple areas at once, select the full range before applying the format.

3. Create a Custom Number Format

Feature entry: Right-click menu → Format Cells → Number tab

1. Select the target cells and open Format Cells.
2. Open the Number tab.
3. Select Custom.
4. Enter the format code you need and click OK.

Success Criteria

• The cells display content according to the custom rule you entered.
• When you reopen the format window, the applied custom type is visible.

Tips While Using

• Custom formats are useful for special identifiers, fixed prefixes or suffixes, and specific display rules.
• Confirm the display result you want before entering the format code.

4. Quickly Apply a Currency Symbol

Feature entry: Home tab → drop-down menu next to the Chinese Currency Symbol button

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

Success Criteria

• The numbers in the selected cells display with the chosen currency style.
• Amounts are easier to read in finance or quotation scenarios.

Tips While Using

• The currency symbol changes the display style only.
• If you also need decimal control, combine this with the decimal place buttons.

5. Quickly Apply Percentage Style

Feature entry: Home tab → Percentage Style button

1. Select the cells you want to format.
2. Click the Percentage Style button to display the values as percentages.

Success Criteria

• The selected cells display percentage values.
• The results can still be used in later calculations and reports.

Tips While Using

• There is a display conversion relationship between the original value and the percentage view.
• For more precise display, continue adjusting decimal places.

6. Quickly Apply Thousands Separator Style

Feature entry: Home tab → Thousands Separator Style button

1. Select the cells you want to format.
2. Click the Thousands Separator Style button to add grouping separators.

Success Criteria

• Large numbers are easier to read with grouped digits.
• The spreadsheet becomes easier to scan.

Tips While Using

• This style is useful for amounts, sales volume, and statistical data.
• If the column is too narrow, adjust the column width as needed.

7. Quickly Increase Decimal Places

Feature entry: Home tab → Increase Decimal Places button

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

Success Criteria

• More decimal places are shown in the selected cells.
• Numeric display becomes more precise.

Tips While Using

• Increasing decimal places mainly affects display precision.
• It is useful for statistics, measurement data, and financial details.

8. Quickly Decrease Decimal Places

Feature entry: Home tab → Decrease Decimal Places button

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

Success Criteria

• Fewer decimal places are shown in the selected cells.
• Reports look cleaner and more compact.

Tips While Using

• This topic is marked as membership-related. Check the current account page for the latest availability.
• Reducing displayed decimal places does not directly change the underlying calculation value.