Special Edition Using® Microsoft® Office Excel 2003

Chapter 4. Applying Number and Date Formats

In this chapter

• Applying Common Numeric Formats from the Toolbar

• Applying Built-In Formats

• Creating Custom Formats

• Applying Custom Currency

• Working with Large Numbers

• Pasting In Custom Characters

• Creating Custom Conditions Codes

• Repeating Characters

Applying Common Numeric Formats from the Toolbar

Numeric formatting changes the appearance of your numbers, displaying them as currency, percentages, dates, phone numbers, and so on. Although this formatting might seem purely cosmetic, it also serves an important purpose in defining the nature of your numbers (do the sales figures represent dollar volume or number of units sold?). It also helps ensure that your numbers appear in a digestible format (reducing the number ...