How do I set the date format in an Excel table?

How do I set the date format in an Excel table?

Steps

1, press CTRL + key at the same time enter the current date, when the date display format is yyyy/m/d.

2, right click on the date entered, in the Pop-up drop-down menu select "Format Cells", you can also directly press the shortcut key ctrl+1 more convenient.

3, click on the date under the Digital menu, in the type of date to select the format you want to click OK. If the date is not in the type, you can click on the customization, then enter yyyy-m-d in the type and click OK.

4, from the figure can be seen, the format of the date has changed, into a yyyy-m-d format.

5, can also adjust the date format of the computer, input directly is the required format. First, click the computer time in the lower-right corner of the notification bar, and then click Change Date and Time settings.

6, click "Change Date and Time" again, then click Change Calendar setting.

7, in the pop-up dialog box, the short date format changed to yyyy-m-d. Press CTRL + key again to enter the current date, when the date is displayed in yyyy-m-d format.

Attention matters

If the date format type is not in the number, you can click Custom Add input.

The above is in the Excel table how to set the date format method Introduction, the operation is very simple, will not friend can refer to, take a look!