O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

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

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.

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