Microsoft Office Tutorials and References
In Depth Information
Enhancing Reporting with Custom Number Formatting
Number formatting basics
To apply a custom number format, follow these steps:
1. Right-click on a range of cells and select Format Cells.
The Format Cells dialog box opens.
2. Go to the Number tab and apply some basic formatting.
To start, choose a format that makes the most sense for your purposes. In Figure 2-10, the
Number format is chosen, with comma separator, no decimal places, and negative numbers
wrapped in parentheses.
Figure 2-10: Choose a basic format.
3. Click the Custom option, as shown in Figure 2-11.
Excel takes you to a screen that shows the syntax that makes up the format you selected. The
syntax is shown in the Type input box. Here you can edit the syntax to customize the number
Figure 2-11: The Type input box allows you to customize the syntax for the number format.
In this case, you see