Now we need to drag from the cell "D2" till all the results are displayed. In our case, we will be using the formula as "A1/100" in the cell "D2" and then press the "OK" button to get the first result, as shown below − Now, click an empty cell where you want to get the first result and enter the formula as "=Address of data/100" as we calculate percentage out of 100. Let us assume we have the following Excel sheet with the given data −
Let us take a simple example to understand how you can add "%" symbol for multiple numbers in Excel. How to Add Percentage Symbol for Multiple Numbers in Excel This tutorial will help you understand how you can add "%" symbol without changing the value of the numbers.
These two methods will not only add the "%" symbol but also multiply the numbers with 100. The first one is to select the data and click the Percentage symbol under the Home menu and the other method is to select the cells and format cells for percentage. When you have to add a Percentage symbol to an existing set of data in Excel, you have two ways to do so.
0 kommentar(er)
