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.
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 ...