Sarah,

Assuming your numbers are in a1 down put this in b1 and drag down
=A1/SUM($A$1:$A$7)

47 7.22%
125 19.20%
60 9.22%
121 18.59%
73 11.21%
203 31.18%
22 3.38%
and you will get this

If you want it exactly as in your post format to 0 decimal places to get this

47 7%
125 19%
60 9%
121 19%
73 11%
203 31%
22 3%


Mike
"Sarah_Lecturer" wrote:

I have the following figures:
47
125
60
121
73
203
22

These total 651

I want to display these as percentages for a report

In Excel I have

7%
19%
9%
19%
11%
31%
3%

Which equals 99% despite Excel rounding to 100%. For the purpose of the
report I need to round one of the figures sensibly so that others do not see
that this does not add up exactly to 100!

Can you help please?

thanks

Sarah xxx