Word 2007 Table Simple calculation and number format conversion

In Word 2007, we can make some simple calculations of the data in the table and transform the data into the format we need.

First, data calculation

Take the table shown in Figure 1 as an example, we need to calculate the sum of each person and the average per quarter.

First position the mouse over the second row at the Sixth column intersection (that is, the F2 cell), where the Table Tools toolbar is added to the ribbon, and the design and Layout tabs are added below it. Click the formula button in the Data feature group on the Layout tab, as shown in Figure 2.

In the Formula dialog box that opens, confirm that the formula in the Formula input field is =sum (left), as shown in Figure 3, and then you can get the total value of the John.

The total number of other people is the same.

As for the average of the quarterly, we can first position the mouse at the intersection of the second column at line sixth (that is, the B6 cell). Still open the Formula dialog box in the above method, the formula in the Formula input column should be "=sum (ABOVE)", we can delete the formula in addition to the equals sign, and then click Paste Function Drop-down button, select AVERAGE in the Drop-down list, and then fill in the parentheses after AVERAGE in the formula column, as shown in Figure 4. Once we're sure, we can get the average we need.

Second, format conversion

As for format conversion, some simple requirements can be implemented in the Formula dialog box. For example, when you click the mouse in cell C6 and open the Formula dialog box, modify the formula, and then click the number Format Drop-down button in the dialog box, we can select the appropriate number format in the Drop-down list, and we'll see how it's done, as shown in Figure 5.

If you want to complete the calculated number in Chinese capital format, then you can copy the number, paste it in the corresponding cell, position the mouse over the Paste Options smart tag that appears, click the small triangle that appears to the right, and select the "Keep Text only" option in the pop-up menu, as shown in Figure 6. We can also use "paste selective" to complete.

Now select the pasted data, and then click the Numbering button in the symbol feature group on the Insert tab of the Ribbon to open the Numbering dialog box. Select the Chinese capitalization format in the number Type list, and then you'll get the results you want, as shown in Figure 7.

Well, if we're just going to do a simple calculation or a simple format conversion to the data in the table, then it's OK to just rely on word 2007.