View original (French)

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   -
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

3 answers

  1. Lentz
     
    Remove the percentage format and multiply your numbers by 100 ;)
    1
    1. 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!)
      0
    2. 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. ;)
      0