Microsoft Office Tutorials and References
In Depth Information
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
this on the Number tab of the Format Cells dialog box (see Figure 49-1). The easiest way to
display this dialog box is to press Ctrl+1. Or, click the dialog box launcher in the Home
group. (The dialog box launcher is the small icon to the right of the word Number. )
Figure 49-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 49-1 and 49-2 for examples of codes you can use to create your own, custom
number formats.
4. Click OK to close the Format Cells dialog box.
Search JabSto ::

Custom Search