Chapter 12. Formatting Worksheets

Change Number Formats

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

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

Get Microsoft® Office 2007 Simplified® 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.