A handy feature of the WPS Office spreadsheet is the ability to quickly convert Arabic numerals that represent amounts into Chinese capitalization (Figure 1).
The operation is very simple: first, the cursor positioned on the cell to be set to uppercase Chinese currency; Then, click on the ' Format ' menu ' cell ', pop-up ' cell format ' dialog box, select ' Special ' in the ' Category ' tab of the ' number ', and then select ' Renminbi capital ' in the ' type ' column on the right (Figure 2 )
Finally click ' OK ' to set it as shown in Figure 1.
The correct input of the ID card number and mobile phone number in the WPS table is also easy to achieve:
First, set the cell format to ' text ' before entering your ID number or mobile phone number.
The operation is as follows:
1. Select the setting area (Figure 3)
2, click the ' Format ' menu ' cell ' command;
3, in the ' Number ' tab in the ' Category ' column, select ' Text ', click ' OK '. (Figure 4)
4, directly enter the ID number, mobile phone number can be.
Note : More attention to the computer Tutorials section, triple Computer office group: 189034526 welcome you to join