So what *does* happen when you copy the formula in G2 to other cells in
the column? Check to make sure Calculation is set to Automatic
(Tools/Options/Calculation).



In article ,
LindaO wrote:

I have a formula in cell G2 that reads: =round(F2,0). I'm using this to
round the value in cell F2 and remove decimal places. The entire "F" column
has values I want to round, and I am unable to "fill" the formula so that I
can get the rounded values of each record in the range. What should I be
looking for?