Set the date format cells

Uploaded time: 2021-08-27 Difficulty: Primary

Set the date format cells

Set the date format cells

Graphic skills

In practical work, we often need to enter the date in the spreadsheet. There are many data format types, so how do we set the date formats as we need?


Take this spreadsheet as an example. Select the spreadsheet area, right-click the mouse, and select Format Cells from the shortcut menu. The shortcut key is Ctrl+1


In the pop-up Format Cells dialog box, select Date. There are many date formats in Type. We can choose the Wednesday date format, its abbreviated format, or the date format of year, month, day and week. After selecting a date format as needed, click OK.



Easy your work with WPS Spreadsheet like Microsoft Excel. Did you get it?