WPS Number Format on Android FAQ

Q: Why is my date displayed as a number?

Select the date cell with the unexpected display. Open Tools → Home → Number Format . Choose the Date category and apply it to see whether the date display returns.

When using Number Format, the most common questions are about display results, text values, and date recognition; this section covers 3 frequent questions.

FAQ

Why did the cell not change after I applied a number format?

Check whether the cell content is stored as plain text.
If the value starts with an apostrophe, remove the text-style input first and try again.
Select the cell again and apply a Number, Currency, or Date format.

Why is my date displayed as a number?

Select the date cell with the unexpected display.
Open Tools → Home → Number Format.
Choose the Date category and apply it to see whether the date display returns.

Does Number Format change the actual value in a cell?

Number Format mainly changes how the value is displayed.
Check the formula bar or later calculation results again; in normal cases, the underlying value is not directly rewritten by a display-format change.
Before applying changes in bulk, test the display result on a small sample first.

Glossary

Term	Definition
Number Format	The display rule used for cell content, such as Number, Currency, Percentage, or Date.
General	The default display style that usually does not apply a specific numeric presentation.
Custom Format	A format type used to define how cell content should appear under a specific display rule.