How to change the date format in WPS Spreadsheet
To change the date format in WPS Spreadsheet, perform the following steps:
1. Select the cell for which you want to set the date format, and tap the toolbar in the lower-left corner.
2. In the expanded toolbar, tap Home, and then tap Format Cells.
3. On the next page, click Number. Then click on Custom and tap the right-side drop-down arrow under Type.
4. Select Date, select the date format that you want to use from the Date Type drop-down list. Then, tap OK in the upper-right corner.
5. The date format is changed successfully.
Was this article helpful?
Yes
No
Not what you're looking for?
You can join our group and post your questions, or submit feedback to our
customer service for support.
Join our Facebook Group
Online Customer Service
