After that hit OK and your decimals will be converted to percentages. Percent Change B - A A When applying this formula to real data it is important that you correctly determine which value is A and which is B. You can calculate all three by dividing the profit revenue minus costs by the revenue.
Right clicking on the selected cell and from the right-click menu selecting the F ormat Cells.
Right clicking on the selected cell and from the right-click menu selecting the F ormat Cells. Method 2 - Percentage Formatting Through the Format Cells Dialog Box. Multiplying this figure by 100 gives you your profit margin percentage. After that hit OK and your decimals will be converted to percentages.