After that hit OK and your decimals will be converted to percentages. Percentage of Total 1. Select the cell s to be formatted.
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.
On the Home tab in the Number group click the percentage symbol to apply a Percentage format. Or move the comma in percentage by 2 characters to the left and perform only multiplication. Method 2 - Percentage Formatting Through the Format Cells Dialog Box. To find a percent of a number use this variant of the formula.