I Ian + Tania Jun 2, 2004 #1 This may be a beginners question, if so I apologise. How do I divide all the individual numbers in a column by 100?
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 Jun 2, 2004 #2 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
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