Tools/materials: Lenovo Y7000P computer, Windows 10 system, Excel14931.20132 version.

1. After entering the Excel table page, right-click the date to be converted, open the drop-down menu, and click Set Cell Format inside.

2. After opening the Cell Format window, select and click the date in the category.

3. In the new page, select and click the date format, and then click OK.

4. After entering the Excel table, select and click the date to be converted, and then click the data option at the top of the page.

5. After opening the data toolbar window, find and click the column option.

6. Enter the column window and select the separator, then click Next.

7. Select the Tab key in the new page, and click Next. After switching pages, click the date, and then click Finish.