My formula was wrong. i was supposed to divide 342 by 3000 to get the correct
answer. (I think) either way i've figured it out thanks

"Sandy Mann" wrote:

That is because 1 is 100% divide you answer by 100 and format as
percentage.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Laserbeak43" wrote in message
...
hI
I can't seem to get excel to show my the right numbers in percent format
i'm dividing a cell of 3000 by a cell of 342 and i get 8.771929825. if i
try
to switch this to percentages i get 877%.

what am i doing wrong?