Hi Sarah
You are ignoring de decimal, just format with one decimal and not only are
you getting 100% , you are not cheating on the figures.

47 =7.2%
125 =19.2%
60 =9.2%
121 =18.6%
73 =11.2%
203 =31.2%
22 =3.4%

Regards
Cimjet

"Sarah_Lecturer" wrote in message
...
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