Excel can format a number as a decimal. This means the decimal .3333333 could be displayed as 33%. Let's see how to make it happen.
Let's see if we can follow the example to produce the following results.
Original Number |
Formatted as a Percent |
.342 |
34.20% |
First we enter the number in a cell. Then with the number selected, we choose Format + Cells. This will bring up the Formatting Choices.
From this panel we select Percentages from the format Categories.
Choose the number of decimal places you wish to display after the decimal.
Note the Sample shows you what the display will look like with your selection.
As a mental exercise, you might think what value you would use in the decimal places field to display exactly 34%. (Comment: Excel will round up and if you set the Decimal places field to 0. That is .345 will be displayed as 35% rather than 34%)