# Percentage to number in Excel

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.

-

## migrated from stackoverflow.comOct 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
Well look at my link above. – brettdj Oct 5 '12 at 14:29

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.

-
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