Excel table numeric conversion method of Chinese character capitalization

You know what? by using cell formatting in Excel, you can turn numbers into uppercase characters. Like "20120205" such a number converted to "the other 0 Year Zero Wooge Zero".

Conversion method:

① Select the cells you want to convert, click Format in the menu bar, and select cells in the down menu.

② Select "Custom" in the "category" below "Numbers" in the Pop-up Cell Format dialog box.

③ in "type" on the right: [dbnum2]0000 year 0 days;

At this point, 20120205 became the 0-year Zero Wooge.