MrExcel Publishing
Your One Stop for Excel Tips & Solutions

excel help

Posted by roger on September 21, 2001 6:27 AM

i am new to excel but i try
so can someone please tell me the formurla for percentage

Posted by Ben O. on September 21, 2001 6:48 AM

If your number is in A2, use =A2/100 to calculate its percentage of 100. If you want to format the result as a percentage, click on the % sign on the toolbar, or select the cell, right-click, select Format Cells, and on the Numbers tab select Percentage under Category.