dividing all cells in a column by a number

  • Thread starter Thread starter Ian + Tania
  • Start date Start date
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?
 
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
 
Back
Top