Simply select the cells to format and then click the Percent Style button in the Number group on the ribbons Home tab. Context to calculate percentage increase Lets say you have your total sales for each month. 1 20 50.
To format the result as a percentage click the Percent Style button in the Number section on the Home tab.
1 20 50. We see the percentage of increase is 27 percent. To increase a number by a percentage amount multiply the original amount by 1 the percent of increase. Context to calculate percentage increase Lets say you have your total sales for each month.