Excel > Excel 2003 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 formatting button you need from the Formatting toolbar

There are five number formatting buttons on the Formatting toolbar.

Currency button

Applies the default currency symbol and 2 decimal places

Percentage button

Converts a fraction to a percentage e.g. .3 to 30%

Comma button

Apply a comma style to thousands

Increase decimal button

Increases the number of decimal places by 1 each click

Decrease decimal button

Decrease the number of decimal places by 1 each click, rounding the number up or down as necessary

You can also format values by using the Format Cells dialogue box. Click Format > Cells and then the Number tab to display the Format Cells dialogue box, or press Ctrl + 1.

Formatting values using the Format Cells dialogue box

Follow us on

Facebook  Twitter  You Tube