WPS automatically convert RMB capital format

Often use WPS in the processing of financial statements, you must have used WPS a very useful function to automatically convert uppercase format. When you set the cell format to "RMB capital", when you enter the number of WPS automatically converted to uppercase, if you enter 321 will be displayed as "three to one yuan to get the whole"

But one drawback is that when you enter a negative number, he will not recognize, such as you enter:-123, also will be shown as red "one hundred to three", printed out can not distinguish whether positive or negative; at the same time, some units are accustomed to the number of capital before the "renminbi capital:" Words. In order to meet the needs of the different capitalization of RMB, we need to make some settings in WPS2009.

The WPS2009 uppercase formatting methods are set in the following ways:

1. Select the columns you want to set to uppercase, select Special-RMB uppercase first in the cell formatting settings, and click OK to exit.

2. Enter the cell settings again, select Custom, drag the right slider to the bottom of the selection box on the right, and the last code [dbnum2][$RMB]g/General format; Red [DBNum2] [$RMB] g/Common format "is the renminbi capital code, click it with the mouse, it will automatically display into the Type input box."

3. Here, we add a few words, make this code simple change, make it become "[dbnum2][$RMB] RMB g/general format;" Red [DBNum2] [$RMB] RMB negative g/general format ".

Now let's try to enter a number in the formatted cell and see if we can get a good indication of what we're asking for.