Add same formula to every cell in the range
Using another column as a helper.
Assuming numbers are in column A and column B as shown
In C1 enter =ROUND(A1,0) copy to D1
Select C1 and D1 then Double-click to copy down.
Gord Dibben MS Excel MVP
On Thu, 7 Aug 2008 12:45:01 -0700, Eastar
wrote:
Thank you Gary, this works.
by the way, can we do this without macro?
thanks,
"Gary''s Student" wrote:
Select the cells you want to convert and run this macro:
Sub round_um()
Set rr = Selection
For Each r In Selection
r.Formula = "=ROUND(" & r.Value & ",0)"
Next
End Sub
--
Gary''s Student - gsnu200798
"Eastar" wrote:
data shown as below
a b
1 5.2312 6.1231
2 15.2323 15.46463
How can I add a round() formula to every cell without doing that to each of
them seprately?
thanks,
|