Microsoft Excel 2003: Division and Percent

Now move to cell A21 and type in the word Percent. We're going to calculate a fun percentage to show you how division works and give you some more practice with numbers.

Now move to cell C21. Using either the Type-In Method or the Point Method, divide ( / ) the amount for Income in cell C9 by the amount for Expenses in cell C17.

[The formula should look like =C9/C17]

This will give you a horrid number so why not put a percent symbol with it. Now we’ll repeat what we did above to format our $$$$.

Point to cell C21 and click the RIGHT mouse button. Point to Format Cells, then click the Number tab, then click-on Percentage. Select zero ( O ) Decimal Places. Click OK. Ta Da !!! a %.