Format numbers


  1. Highlight cells B4 through B7.

    TUTORIAL EXCEL 2007

  2. In the Ribbon, click the icon

  3. Click the worksheet.

    The numbers should look like this:

  4. In the same way, format all the numbers in the worksheet (except the Subsidies years and Profit Margin) as currency.

    The worksheet should look like this:

  5. Click cell I4.
  6. In the Ribbon, click the icon.

  7. Click the icon twice more.

There should be three decimal places remaining:

    In the Ribbon, click the icon.

    The number should change to percent: