Microsoft Office Tutorials and References
In Depth Information
Tip 16: Creating Custom Number Formats
Creating Custom Number Formats
Although Excel provides a good variety of built-in number formats, you may find that none of them
suits your needs. In such a case, you can probably create a custom number format. You do so on the
Number tab of the Format Cells dialog box (see Figure 16-1). The easiest way to display this dialog
box is to press Ctrl+1. Or click the dialog box launcher in the Home➜Number group. (The dialog box
launcher is the small icon to the right of the word Number. )
Figure 16-1: Create custom number formats on the Number tab of the Format Cells dialog box.
Many Excel users — even advanced users — avoid creating custom number formats because they
think that the process is too complicated. In reality, custom number formats tend to look more
complex than they are.
You construct a number format by specifying a series of codes as a number format string. To enter a
custom number format, follow these steps:
1. Press Ctrl+1 to display the Format Cells dialog box.
2. Click the Number tab and select the Custom category.
3. Enter your custom number format in the Type field.
See Tables 16-1 and 16-2 for examples of codes you can use to create your own, custom
4. Click OK to close the Format Cells dialog box.