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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA multiple list of values for variable 1
Divide a # into 3 #'s rounded to a whole # 9
Combining three files when middle file has sections with endnotes 2
Dividing after a long formula 5
Excel does not accept text format! 0
Divide two cells and if the number is negative display is as zero 2
Two columns : Continuous two columns vs Parallel two Column 1
Multiple text-number in cell divider formula? 1

Top