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.
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.
Now drag the formula till row 5 to accommodate all the data.
As you could see we have extracted numbers without the percentage sign in excel.
Hope this helped.