Help Center

Payment Issue

Basics

Writer

SpreadSheet

Presentation

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. In the page that appears, 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.

数据格式.png



5. The date format is changed successfully.

微信图片_20230406145238.png


Not what you're looking for?

You can join our group and post your questions, or submit feedback to our customer service for support.
facebook Join our Facebook Group