Question: how do you convert a percentage to a whole number in excel?
Answer: Let's make that a little cleaner. Highlight the column, right-click, and select Format Cells… Select Number from the Category menu, and click the down arrow next to Decimal Places until it reads “0.” Click OK, and you'll see that the percentage scores have been rounded to the nearest whole number.