trying to add a / 2 to multiple selected cell to my formulas

[Beta4]

I hope I have posted this in correct spot- this is my first time.

So I have a bunch of cells with formulas lets say these for example
126 * 0.7
231 * 0.7
315 * 0.7
378 * 0.7
420 * 0.7
etc.

I want to add a / 2 to divide all of them by 2 so they look like this
126 * 0.7 / 2
231 * 0.7 / 2
315 * 0.7 / 2
378 * 0.7 / 2
420 * 0.7 / 2
etc.

Any help would be appreciated. Thanks again.

[MarvinP]

Hi Beta4 and welcome to the forum,

Instead of changing the formula, you can select a bunch of cells and divide all those values by 2. You put a 2 in a blank cell and then copy that cell into the windows buffer. (Press Ctrl-C)
Then select all those cells you want to divide by 2 and click on Paste Special. Choose divide and poof - done...
Read about this at:
http://www.techrepublic.com/blog/mic...ting-in-excel/

[Beta4]

Well I wanted to add the / 2 to the formulas so I could see them visually. But I do appreciate that info though.