Question

How to add percentage to a number in excel?

Answer 1

Enter the numbers you want to multiply by 15% in an empty column.

In an empty cell enter the percentage, which would be 15%, and then copy that number by pressing Ctrl + C.

Select the range of cells in cells in A1:A5 by dragging down the column.

Right click the selected cells, and then click Paste Special (do not click the arrow next to Paste Special).



Click Values > Multiply. Click OK.

And here’s the result: all the numbers multiplied by 15%.