Anatomy of Word: Taking Word tables to the next level
For these formulas, I left the Number format box empty
However, you don't actually have to indicate anything in the Number format box. Word also helps you with this. If, for example, one of the numbers in your table column has a dollar sign on it, Word will assume that the formula result should also be a monetary figure and will tack on the dollar sign to the result for you. Take a look above to see what I mean.
Note that for the examples shown here, I left the Number format option empty, which allowed Word to make its own decision about how to format the results. For any column or row that had even a single figure with a dollar sign, Word formatted the results as a monetary figure. For column and row calculations in which all of the figures were just numbers with no dollar sign, Word maintained this plain formatting.
Another item to note: I mentioned that Word makes an attempt to give you the appropriate formula depending on where you locate your cursor. Take a look at the table above again and locate the cell that holds the total value spent for electricity. The figure in it is 405. When I selected this cell and went to Table | Formula, Word didn't give me =SUM(LEFT), but gave me =SUM(ABOVE) instead. This is because there was a figure already present immediately above this cell (the cell that has the $2625.00 result). As I mentioned, Word tries to help you out, but can't always get it right.
Note that for the examples shown here, I left the Number format option empty, which allowed Word to make its own decision about how to format the results. For any column or row that had even a single figure with a dollar sign, Word formatted the results as a monetary figure. For column and row calculations in which all of the figures were just numbers with no dollar sign, Word maintained this plain formatting.
Another item to note: I mentioned that Word makes an attempt to give you the appropriate formula depending on where you locate your cursor. Take a look at the table above again and locate the cell that holds the total value spent for electricity. The figure in it is 405. When I selected this cell and went to Table | Formula, Word didn't give me =SUM(LEFT), but gave me =SUM(ABOVE) instead. This is because there was a figure already present immediately above this cell (the cell that has the $2625.00 result). As I mentioned, Word tries to help you out, but can't always get it right.
