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

  4. If the formatting isn’t what you want, click the Format Cells: Number button.

  5. On the Number tab of the Format Cells dialog box that appears, select the type of formatting you want.

  6. Select any available options you want to use to customize the formatting.

  7. Click OK when you’ve finished.

    Format Some Numbers

Tip

Tip

If you’re applying an accounting number format (currency), click the down arrow at the right of the Currency button, and choose the type of currency you want from the drop-down menu.

Tip

Tip

To select non-adjacent rows or columns, hold down the Ctrl key as you click each row or column header.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset