The date format in Excel is quickly converted to XX year XX month XX day style

Create an Excel table that requires a date time in the table to be normalized. Automatically converts the date format "20141201" to "December 01, 2014" as shown in the figure

Select "20141201" that needs to be converted to date, and choose "Format cells" with the right mouse button.

In the Format cells text box that jumps out, select the custom item under the Number tab.

In the Format Cells text box, fill out the type as "### #年 # #月 # #日.

View the current page effects, as shown in the figure.

Now test the bulk operation, whether you can also achieve the desired effect.

Select the B5-b8 table, right-click Format cell, and set the type of custom item under the Number tab to ### #年 # #月 # #日, as shown in the figure.

View the effect of the bulk operation conversion date display format, as shown in the figure.

Attention matters

If an operation fails, and you try to remove the cell format, you can successfully manipulate it.