Percentage issue in Excel?
Solved
Vilmaa
Posted messages
8
Registration date
Status
Member
Last intervention
-
Vilmaa Posted messages 8 Registration date Status Member Last intervention -
Vilmaa Posted messages 8 Registration date Status Member Last intervention -
Hello,
I have an Excel 2007 spreadsheet that contains 3000 thousand rows of data, in which I have a column that contains values written in the form of a real number followed by the % symbol (1.87%, 6.98%, ...). My issue is that I don't know how to remove the percentage from each value in the column to get it like this (1.87, 6.98,...). Is there a trick or a function I can use to solve this?
I would be grateful if someone could respond. Thank you.
Configuration: Windows XP / Safari 535.1
I have an Excel 2007 spreadsheet that contains 3000 thousand rows of data, in which I have a column that contains values written in the form of a real number followed by the % symbol (1.87%, 6.98%, ...). My issue is that I don't know how to remove the percentage from each value in the column to get it like this (1.87, 6.98,...). Is there a trick or a function I can use to solve this?
I would be grateful if someone could respond. Thank you.
Configuration: Windows XP / Safari 535.1
3 answers
Vilmaa
Posted messages
8
Registration date
Status
Member
Last intervention
1
Thank you, but I can't do that manually (the table has 3000 rows!)
Lentz
Add a column (example B) where you do A2*100 in B2, then drag down. Add a column (C) where you do a special paste of values from B to C, and then you delete columns A and B. ;)