Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Oct 8 '12 at 11:30

This question came from our site for professional and enthusiast programmers.

    
Why do you want to do it in VBA? You can do that via Excel menus as well? –  Siddharth Rout Oct 5 '12 at 14:24
    
You can use multiply all the values by 100, then reformat as numbers rather than percentages. One quick way here j-walk.com/ss/excel/usertips/tip059.htm. This is really a formula question for Super User –  brettdj Oct 5 '12 at 14:24
    
Selecting them all and changing the format to number isn't enough? –  mattboy Oct 5 '12 at 14:27
    
I want any fast way. Not necessarily VB. But I don't know how to use any of the functions in excel. I need steps. –  TravelingSalesman Oct 5 '12 at 14:29
1  
Well look at my link above. –  brettdj Oct 5 '12 at 14:29
show 2 more comments

1 Answer

up vote 3 down vote accepted

Select the column, right click, select Format Cells, go to the Number tab, select Number under category and select the number of decimals you want to appear in the Decimal places field.

share|improve this answer
1  
Are you sure you understand what I want? I don't want to change the number of decimal places. I want to convert the percentage to a number. Meaning I want to divide the number in the percentage over 100 –  TravelingSalesman Oct 5 '12 at 14:43
    
If this isn't what you want, then no. –  mattboy Oct 5 '12 at 14:45
1  
Have you tried doing this? –  mattboy Oct 5 '12 at 14:52
    
If I didn't try it, I wouldn't have rated you up ;) That's perfect. Thanks. –  TravelingSalesman Oct 5 '12 at 15:00
2  
(what a weird set of comments) –  whytheq Oct 7 '12 at 20:24
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.