Excel does not provide such a function directly, and to implement this transformation requires several function formulas to be called, and the complexity is sufficient. Well now, because the latest version of WPS Table 2007 provides such a feature, simply set up to capitalize the RMB lowercase.
1. Start WPS Form 2007 and open the Excel workbook file that you want. WPS Table 2007 is fully compatible with Excel, not only to open an Excel workbook file, but to save the new file in Excel format directly.
2. Select the range of cells for which you want to convert the number of uppercase digits, and then, on the Format menu, click Cells.
3. Click the Number tab, click Special in the Category box, and in the Type box on the right, click RMB Capital (figure), and click OK. What do you want to capitalize on the renminbi?
Figure WPS2007 Cell formatting