Re-Divide all my Excel cells by 100
Solved
SL
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur 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
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 réponses
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?
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?
Have a good day,
SL