How does excel format the date?

1. Open a new table with Excel software and select the date range to edit.

2. Find the Start menu, then find the Data option, and click the Separate option in the Data option.

3. Click the Column option, and then see the Text Column Wizard dialog box.

4. Under the Text Sorting Wizard, directly select the next option.

5. Then select the date "YMD" and click "Finish".

6. Then the date field to be edited has a uniform format.

7. Select the table to edit for this column, right-click and select the Cell Format option.

8. Open the Cell Format option, and then select the Date option in the Number column.

9. Select English (Australia) in Regional Settings.

10. Click the first "200 1-03-07" in the Type option above, and then click OK.

1 1, and the final effect is as follows: