View original (French)

Percentage sign in Excel software

Solved
mimijo13 Posted messages 25 Status Member -  
mimijo13 Posted messages 25 Status Member -
Hello,

I no longer know how to incorporate the % sign into a cell after calculating it.
I do my formula for calculating the percentage example:
what is the percentage of 50 out of 500? I do 50 divided by 500 equals 10
in the concerned cell the result is 10 but without the % sign.
Thank you for your response.

Configuration: Windows XP / Chrome 21.0.1180.89

1 answer

  1.
    f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717
     
    Hello,

    Cell format------> number------> percentage
    1
    1. mimijo13 Posted messages 25 Status Member
       
      Thank you for the response, but it doesn't work, which is why I'm seeking help.
      I want the percentage sign to appear in the concerned cell where the percentage number should be, and where I've done the calculation formula, but that's impossible.
      I found a solution to insert a column right next to it and put the sign there. Afterwards, it's a matter of layout.
      0
    2. f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717
       
      Re,
      In your calculation formula add: & "%".

      To be seen.
      1
    3. mimijo13 Posted messages 25 Status Member
       
      Okay, that works.
      Thank you very much.
      0