Question

State the process of formatting a group of numbers in excel so that it displays 2 digit after the decimal.

Answer 1

Click the Table Tools' Layout tab, select Data and then click Formula. Click the Number Format menu and select 0.00 for two decimals. Delete the default =SUM(ABOVE) formula and type the formula you used in Excel based on the cell locations in Word's table. In this example, the formula is =AVERAGE(B2,B3).