=B1/70

copy down (this assumes the first number is in B1) Then format as percentage

--
Regards,

Peo Sjoblom


"LMB" wrote in message
...
Excel 2000. This may be too complicated but everything else I have asked
in here has been answered and works great. I have a column of numbers
(column 8). These numbers are the result of the count function. I have
70 records. Some of the counts are 0, some 1, 2, 3, 4, 5, 6. I want to
report the % of each of these numbers.

Example: If I have 10 records and 5 of thenumbers are = to 6 then the
answer will be 50%. I would like to report the % of each number when
compared to the total number of records.

Thanks,
Linda