How the WPS table formats text

Converts the Arabic numerals that represent amounts to the Chinese capital form (Figure 1) simply and quickly.

Figure 1

First, the cursor is positioned on the cell that you want to 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 ' number ', and select ' renminbi capital ' in the ' type ' column on the right (Figure 2)

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)

Figure 3

2, click the ' Format ' menu ' cell ' command;

3, in the ' Number ' tab in the ' Category ' column, select ' Text ', click ' OK '. (Figure 4)

Figure 4

4, directly enter the ID number, mobile phone number can be.