O'Reilly logo

Teach Yourself VISUALLY™ Microsoft® Office 2007 by Sherry Willard Kinkoph

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

Chapter 12. Formatting Worksheets

Change Number Formats

You can use number formatting to control the appearance of numerical data in your worksheet. For example, if you have a column of prices, you can apply currency formatting to the data to format the numbers with dollar signs and decimal points. Excel offers several different number categories, or styles, from which to choose.

Change Number Formats

Change Number Formats

  • Change Number Formats

    Note

    See Chapter 9 to learn how to select cells; see Chapter 11 to learn about ranges.

  • Note

    You can apply number formatting to single cells, ranges, columns, ...

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