Excel 2007 Formatting - number formatting
Note: For help on these steps, refer to the image above.
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
