If you are using Excel for the web click Home Number Format Percentage. B5-B4B5 Step 2 Excel displays this as a decimal so click the Percent Style button on the Ribbon or use the above mentioned shortcuts to format it as a percent. The percentage of change between the two years is 23.
In the Number tab of the resulting menu click Percentage.
If you are using Excel for the web click Home Number Format Percentage. As with any formula in Excel you need to start by typing an equal sign in the cell where you want your result followed by the rest of the formula. For example if you want to calculate 25 of 50 multiply 25 by 50. Percentage of Total 1.