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