How to Do Percentages With Excel 2003

Updated April 17, 2017

Create percentages in Excel 2003 by using a percentage formula and the percentage formatting icon on the formatting button. Create the percentage formula by using the data in your Excel spreadsheet. Divide the amount by the total value to generate the percentage. Once this value is determined, use the percentage icon to determine the percentage. When the percentage icon is used, you will see the percentage symbol appear on your spreadsheet.

Open Excel 2003, and open a workbook that contains a column with amounts and another column with totals. Click "File" on the menu bar, and click "Open." Browse your files, and locate the workbook. Click the workbook and select the "Open" button. The workbook opens.

Click in the next available column in your workbook. Type "=." Click in the first cell that contains the first amount. Type "/." Click in the first cell that contains the first total, and press the "Enter" key. A value is generated.

Highlight the column containing this new formula. Click the "%" symbol on the standard toolbar. Your value is transformed into a percentage.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Emmanuelle Douglas has been an avid writer since 1990. Her first professional writing assignment was for "Oscar News," a local corporate Intranet website. She holds a Bachelor of Science in mathematical sciences from Clemson University.