Excel > Excel 2007 Foundation > Formatting a worksheet

Formatting Values

Applying number formatting changes the appearance of the cell contents and not its value. This includes increasing or decreasing decimal places, formatting as a currency and formatting as a percentage.

Often Excel will apply the formatting for you. For example if I enter 20%, Excel will format the cell as a percentage.

To format values:

  1. Select the cell(s) you wish to format
  2. Click the Home tab, and click the formatting button you need from the Number group

The Number group on the Ribbon

You can also format values by using the Format Cells dialogue box. Click the Dialogue Box Launcher arrow in the bottom corner of the group to display the Format Cells dialogue box, or press Ctrl + 1.

Formatting numbers in Excel

Follow us on

Facebook  Twitter  You Tube