Help Center

Payment Issue

Basics

Writer

SpreadSheet

Presentation

Payment Issue-会员合并使用(勿更改)

Basics-会员合并使用(勿更改)

AI credit

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