Creating Custom Formats

Use the Custom tab in the Format Cells dialog box, shown in Figure 8-14, to create custom number formats using special formatting codes. Excel adds new formats to the bottom of the list of formatting codes in the Type list, which also includes built-in formats. To delete a custom format, select the format in the Format Cells dialog box and click Delete. You cannot delete built-in formats.

Use the Custom category to create new formats using special codes.

Figure 8-14. Use the Custom category to create new formats using special codes.

Creating New Number Formats

The quickest way to start creating a custom format is to use one of the existing custom formats as a starting point for creating your ...

Get Microsoft® Office Excel 2003 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.