Operator function across a range of cells

[Dublevay]

Is there any way that I can simply select a range of cells, and then divide
the value of them all by two? I'm ideally after a way to do this without
using VBA.

Thanks

JW

 

[J.E. McGimpsey]

Put 2 in an empty cell. Copy the cell.

Select your range. Choose Edit/Paste Special, selecting the Values
and Divide radio buttons. Click OK.

Clear the cell in step 1.

 

[Dublevay]

Wow! As simple as that. Many thanks!

JW

Put 2 in an empty cell. Copy the cell.

Select your range. Choose Edit/Paste Special, selecting the Values
and Divide radio buttons. Click OK.

Clear the cell in step 1.