Applying Number Formatting
Number formatting refers to the addition of currency symbols, decimal markers, percent signs, and other symbols that help to identify the type of data present in a cell and to make it easier to read.
In this step we add percent signs and currency symbols to our data.
Adding the percent symbol
- Select cell C6.
- Click on the Format menu to open the drop down list.
- Click on Cells.. option to open the Format Cells dialog box.
- Click on Percentage under the Category list.
- Click OK.
- The data in cell C6 should now read as 6 %.
Adding the currency symbol
- Drag select cells B9 - D12.
- Repeat steps 2 and 3 above.
- Click on Currency under the Category list.
- Click OK.
- The data in cells B9 - D12 should now show the dollar symbol ( $ ) and two decimal places.
