Operation method
First, click to open Excel, and then click the drop-down arrow next to General in the toolbar;
In the pop-up interface, click other number formats;
In the pop-up interface, we can select a date. There are many types of dates;
We select one, as shown in the figure, and then click OK; In this way, the cell we click will be set by us.
Then we enter 2017/12/12 in the cell and press Enter. The displayed date format will change to the format we just set, as shown in the figure. You can select the format you want to set in the category.