How to Use WPS Number Format on Android

Use Number Format through 3 how-to topics: open the Number Format entry, apply a cell number format, and check why a format did not take effect; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Open the Number Format entry

Feature entry: Tools → Home → Number Format

1. Open a WPS spreadsheet file.
2. Tap the Edit button in the lower-left corner to enter editing mode.
3. Select the target cell or cell range.
4. Tap Tools.
5. Switch to the Home tab.
6. Tap Number Format to view the available format types.

Success Criteria

• Interface result: You can see the available number format options.
• Next action available: You can continue to choose General, Number, Currency, Percentage, Date, or Custom formats.

Tips While Using

• Common mistake: If you do not enter editing mode first, you may not see the full editing path.
• Environment note: The current file must support editing.

2. Apply a number format to cells

Feature entry: Tools → Home → Number Format

1. Select the target cell range in the spreadsheet.
2. Open the Number Format panel.
3. Choose General, Number, Currency, Percentage, Date, or Custom based on your needs.
4. Tap the target format to apply it to the selected range.
5. Return to the sheet and review the display result.

Success Criteria

• Interface result: The selected cells display content in the chosen format.
• Next action available: You can continue editing, saving, or adjusting other cell formats.

Tips While Using

• Common mistake: If you do not select cells first, the format may not apply to the intended range.
• Environment note: Different data types work better with different format categories.

3. Check why the format did not apply

Feature entry: Reopen Number Format after selecting the cell

1. If the display does not change after you modify the number format, first check whether the cell content is stored as text.
2. See whether the value starts with an apostrophe or was entered as text.
3. If needed, adjust the content so it can be displayed as a numeric value.
4. Open Number Format again and choose the target format.
5. Check the cell display result again.

Success Criteria

• Interface result: The cell that did not change before now displays in the target format.
• Next action available: You can continue working with dates, amounts, or percentages.

Tips While Using

• Common mistake: Applying a numeric format directly to text content may appear to do nothing.
• Environment note: If a date is shown as a number, switching to a Date format usually restores a standard date display.