Extract Only Number From Percentage In Excel

In this post we will see how we could extract only the number part from a percentage figure in excel.

Actually when we extract the numeric part in the percentage figure we get values between 0 and 1 like 0.9, 0.7 corresponding to 90 % and 70 % respectively.

Below is the data and the extracted number that we wish to extract from a percentage figure.


table showing numbers extracted from percentage

We will use ROUND function in excel to extract the numeric part of the percentage, the idea extract the actual value and then multiply them by 100 and rounding to nearest integer.

Enter the formula =ROUND(A2*100,0) , here in this formula we are multiplying the actual value by 100 so basically it gives the same name as the percentage denotes.

formula showing extraction of number from percentage

Now drag the formula till row 5 to accommodate all the data.

numeric values extracted from percentage

As you could see we have extracted numbers without the percentage sign in excel.

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply