Microsoft Office Tutorials and References
In Depth Information
Figure 9.24. When you apply a numeric format, the answers are correct.
When you apply a numeric format, the answers are correct.
Any time you are doing math between two dates, you should plan to change the
format of the result to be either Number or Date, depending on the situation.
It is difficult to figure out worksheets that were set up by other people. When
you receive a worksheet from a co-worker, use the information in the follow-
ing sections to find and examine the formulas.
Highlighting All Formula Cells
The first technique to use when examining a new worksheet is to find all the
cells that contain formulas. The following steps identify all the formula
cells in the worksheet:
11. Ensure that you have a single cell selected.
22. Press F5 to display the Go To dialog.