Excel Formatting - 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 Home tab.
- Click on the Percent style option on the ribbon.
- The data in cell C6 should now read as 6%.
Adding the currency symbol
- Drag select cells B9 - D12.
- Click on the General option on the ribbon to open the Number Format drop down list.
- Select Currency from the list.
- The data in cells B9 - D12 should now show the dollar symbol ( $ ) and two decimal places.
Return to Index page
