This FAQ covers 3 common question types about WPS Number Format on iOS, including formats not taking effect, dates showing as numbers, and how preset custom codes work.
FAQ
Why did the cell not change after I applied a number format?
- Check whether the cell content is stored as text, such as with an apostrophe at the start.
- Change the content into a recognizable number or date if needed.
- Apply the number format again and review the updated display.
Why is a date showing as a number?
- This usually means the cell is still using a General or Number format.
- Select the cell and open Number Format.
- Choose the Date category and check whether the display returns to a date style.
Do preset custom format codes change the original value?
- No. Preset custom format codes mainly change how the value appears.
- For example,
0000can display an ID as four digits while the stored value still follows its original calculation logic. - If needed, check the original content in the editing area.
Glossary
| Term | Definition |
|---|---|
| General | The default display style for values, usually without a specialized number rule. |
| Preset custom format code | A formatting expression used to control how a value appears, such as adding zero-padded IDs, units, or a date pattern. |
| Percentage format | A display format that shows a value as a percentage, such as showing 0.85 as 85%. |