Microsoft Office Tutorials and References
In Depth Information
Enhancing Reporting with Custom Number Formatting
You can get fancy and wrap your negative percentages with parentheses with this syntax:
This syntax gives you percentages that look like this:
If you include only one format syntax, meaning you don’t add a second formatting
option with the use of a semicolon separator, that one format will be applied to all
numbers—negative or positive.
Formatting numbers in thousands and millions
Earlier in this chapter, you formatted your revenue numbers to show in thousands. This allowed you
to present cleaner numbers and avoid inundating your audience with too much ink. To show your
numbers in thousands, follow these steps:
1. Highlight the cells containing your numbers, right-click, and select Format Cells.
The Format Cells dialog box appears.
2. Click the Custom option.
The screen shown in Figure 2-12 appears.
Figure 2-12: Go to the Custom screen of the Format Cells dialog box.