Hi

Enter 30 into some free cell, and copy this cell;
Select the range with data you want to convert, and PasteSpecialDivide;
Format the converted range as percentage;
[Clear value 30 entered at start]


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"showsomeidnow" wrote in message
oups.com...
hi. i have a list of pupil data in column A. The total number of
pupils in the class is 30 and i wish to convert the data into a
percentage but i have to do this individually for each cell. for
example (in column B)
=15/30
=10/30
=5/30 etc etc.

is there an easier way to do this? thanks all.