Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In Excel, I have a large column with percentage values, something like this :


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 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 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
Well look at my link above. – brettdj Oct 5 '12 at 14:29
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
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
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
(what a weird set of comments) – whytheq Oct 7 '12 at 20:24

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .