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!