In Excel, I have a large column with percentage values, something like this :
N% N% N% .. ..
I don't want them to appear as percentages. I want to convert each percentage to the corresponding double value and eliminate '%' at the end. How can I do that in excel? Thank you.