Formatting Numbers

When you look at columns and rows stacked full of numbers, it isn’t always immediately clear what those numbers represent. Do they indicate currency? Are they percentages of something? You can improve the readability of your workbook by using standard numeric formatting to make everything as clear as possible.

Format Some Numbers

  1. Select the columns, rows, or cells that contain numbers that will all be formatted in the same way.

  2. Select the type of numbering format to be used.

  3. Use the buttons on the Formatting toolbar to modify the ...

Get 2007 Microsoft® Office System Plain & Simple 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.