How to Use WPS Number Format on macOS

Use WPS Number Format through 4 topics, including toolbar formatting, right-click formatting, keyboard shortcut access, and custom number formats; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Format cells from the toolbar

Entry: Home tab → Number format drop-down

1. Select the cell or cell range that you want to format.
2. Click the Home tab at the top of the window.
3. In the Number group, open the format drop-down list.
4. Select the format you want, such as Number, Currency, Percentage, or Short Date.
5. Check whether the selected cells now display the new format.

Success Criteria

• Interface result: The selected cells display content in the chosen format.
• What you can do next: You can continue editing, copying, or saving the worksheet.

Tips While Using

• Common mistake: If you do not select the target cells first, the format may not be applied to the intended range.
• Environment note: If the cells are protected, formatting may not be available.

2. Format cells from the right-click menu

Entry: Select cells → Right-click → Format Cells

1. Select the target cell or range.
2. Right-click the selection and choose Format Cells.
3. In the dialog box, open the Number tab.
4. Choose a category such as Number, Currency, Date, Text, or Custom.
5. Adjust settings such as decimal places, currency symbols, or format codes as needed.
6. Confirm the settings and return to the worksheet to review the result.

Success Criteria

• Interface result: The selected number category and settings take effect.
• What you can do next: You can repeat the same method for other cells.

Tips While Using

• Common mistake: If you change the category but do not confirm the detailed settings, the result may not match your expectation.
• Environment note: Some display results may also depend on column width.

3. Open number formatting with a keyboard shortcut

Entry: Select cells → Command+1

1. Select the target cell or range.
2. Press Command+1 to open the Format Cells dialog box.
3. On the Number tab, choose the format category you need.
4. Adjust the detailed settings and confirm the change.
5. Return to the worksheet and review the display result.

Success Criteria

• Interface result: The shortcut opens the formatting dialog directly.
• What you can do next: After the change, you can continue editing the worksheet.

Tips While Using

• Common mistake: If another app or input method uses the same shortcut, the dialog may not open as expected.
• Environment note: Make sure the WPS Spreadsheet window is active before using the shortcut.

4. Create a custom number format

Entry: Format Cells → Number → Custom

1. Select the target cell.
2. Open the Format Cells dialog from the right-click menu or by pressing Command+1.
3. On the Number tab, choose Custom.
4. Enter the format code you want in the Type box.
5. For example, you can use 0, 0.00"yuan", yyyy-mm-dd, or 00000 depending on the display you need.
6. Confirm the setting and check whether the result matches your expectation.

Success Criteria

• Interface result: The cell displays content according to the custom format code.
• What you can do next: You can copy the same format to other cells.

Tips While Using

• Common mistake: An incorrect format code can cause unexpected display results.
• Environment note: A custom number format changes display only and does not directly change the stored value.