How to convert the year, month, and day format: First open the Excel file; then right-click on the cell to be changed, and click to set "Cell Format"; then click "Date"; and finally select the format of the year, month, and day. , and click "OK".

The operating environment of this article: Windows8 system, Microsoft Office Excel2007, Dell G3 computer.

1. First enter the date in excel in the format of month, day and year.

#2. Right-click the cell you want to change and click Format Cells.

#3. Click on the date and select the desired format. Here, select the format of year, month and day, which will be displayed in the example.

#4. Click OK to convert it to year, month and day format. [Recommended: Excel Tutorial]

The above is the detailed content of How to convert year, month, day format. For more information, please follow other related articles on the PHP Chinese website!