O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required