View original (French)

Re-Divide all my Excel cells by 100

Solved
SL -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello,

I'm in trouble. I created a spreadsheet in Excel. I made formulas like
=(30*100)/55 to calculate averages with numbers. And I manage to get numbers but they don't show up as percentages. When I click on percentage, my 55% turns into 5492%, which doesn't work for me... I would need to divide everything by 100 again. But how can I do that? All my cells have different formulas...

I tried cell formatting = 0 ##0 but it changes my 5492 back into 54 and without the %.

I guess I'm doing something wrong... I'm a bit useless on Excel, but right now I don't see how to do it other than going back and fixing each cell one by one...

Any ideas?

Thanks,

SL

Configuration: Windows Vista / Safari 534.16

5 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello

    enter 100 in a cell
    Copy it
    select the field to process and
    special paste / Division

    if the cell contains a number, it will be divided by 100, if it contains a formula, it will become:
    =(formula)/100

    for example, your:
    =(30*100)/55
    will become =((30*100)/55)100
    it’s not very orthodox, but it gives the desired result

    you can also, but it's riskier depending on the formula configuration, use the replace function
    select the field
    Edit / Replace
    at the top: *100)
    at the bottom by: *)
    the only risk being to see a *100) replaced by a *1) when it wasn't meant for the sought calculation.

    sincerely

    Let’s ask ourselves if we are not alone in understanding what we are explaining?
    19
    1. SL
       
      Great, thanks, that works! I will save time this way! It's great!

      Have a good day,

      SL
      0