dividing all cells in a column by a number

I

Ian + Tania

This may be a beginners question, if so I apologise. How
do I divide all the individual numbers in a column by 100?
 
R

Ron de Bruin

Hi Ian + Tania

Enter 100 in a empty cell and copy that cell
Select your range with numbers
Right click and choose PasteSpecial
Check Divide
OK
 
Top