Hour 9. Changing the Look of Values

The topics covered in this hour include the following:

  • What formats are available

  • How to choose a number style

  • How to work with decimal places

  • How to design custom numeric formats

  • How to format conditionally

  • How to hide zeros

  • How to work with dates

During this hour you get all the information you need on how to format numbers—from finding out what number formats are available in Excel to choosing number styles, working with decimal places, designing your own number formats, using conditional formatting, hiding zeros, and working with dates.

At the end of this hour, you'll be a pro at formatting numbers with Excel's formatting tools, making your numbers clearer to read and understand.

Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.