How do you convert a 8-digit number to date format in Excel?

How do you convert a 8-digit number to date format in Excel?

1, in Excel 2010 as an example: Open an Excel table file that contains a text-type date, as shown in the red box as a text-type date, as shown in the figure:

2, select all date cells, a square exclamation point, as shown in the figure:

3, the mouse pointing to the exclamation point, we click "Inverted triangle"-〉 "Convert to Number":

4, after the click, the text type has been converted into a digital type, as shown in the figure:

5, then the mouse points to the selected date cells, right-click-〉 "Format cells":

6, pop-up "Format Cells" window, click on "Number"-〉 "Custom", type "0000-00-00" below, as shown in the figure:

7, click "OK", the effect as shown in the picture: