Formatting Numbers

You can change the appearance of the data in the cells of a worksheet without changing the actual value in the cell. You can apply numeric formats to numbers to better reflect the type of information they represent—dollars, dates, decimals, and so on. For example, you can format a number to display up to 15 decimal places or none at all. If you don’t see the number format you need, you can create a custom one.

Format Numbers Quickly

image Select a cell or range that contains the number(s) you want to format.

image

Click ...

Get Office 2008 for the Mac on Demand now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.