WPS Table Function--Automatically generate RMB capital

For many financial personnel, daily with the form of dealing with is the most common thing, a variety of reports, various data, various calculations, complex and cumbersome. Miss Sun is considered a "table family" old members, for table Operation Dare not say that the know-it-all, also can be regarded as a person, today she to the financial compatriots to introduce a commonly used in the WPS table function-automatically generate renminbi capital.

The expense ticket and the writing payroll usually convert the value to the renminbi capital format. It can be cumbersome to Excel by setting a formula. Use the WPS table to convert just select the text you want to modify, find the Formatting button on the toolbar, and select the cell format.

Figure 1 Computer Tutorials

In the presence of the Number tab in the window select the "Special" category in the "Renminbi capital", click "OK" on the OK!

Figure 2

Figure 3