If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want the percentage of. Enter a decimal number 02 in cell B1 and apply a Percentage format. Just right-click on a cell that contains a decimal or a row or column full of such cells and select Format Cells.
The main condition is the corresponding icon on the keyboard.
We will use two buttonsone to format the cell value as a percentage and another to reduce the number of decimal places so that the cell only shows the tenths place. Simply select the cells to format and then click the Percent Style button in the Number group on the ribbons Home tab. To count the percentage of the number add and take percentages on a modern calculator is not difficult. Number percent 100.