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:
- Select the cell(s) you wish to format
- Click the Home tab, and click the formatting button you need from the Number group
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.