Format the cells directly, and then select the custom input matching type. Below I will demonstrate the detailed operation steps:

(computer model: MacBook Air, software version: Excel 202 1)

1. Open Excel, click the right mouse button and set the cell format;

2. A light gray box pops up, and click Customize in the lower left corner;

3. Enter the matching type: yyyy-mm-dd;

4. Click OK in the lower right corner;

5. Set the date of birth format yyyy-mm-dd!

The above is a tutorial on how to set the birth date format yyyy-mm-dd. I hope it helps you ~