Rounding 2 decimal Places

[petedacook]

This seems easy enough but I cannot figure out the code and I cannot find an
example.

I need to round cells so there is 2 decimal places. I just need standard
rounding so there is no more than 2 decimal places.

This is what I did, but i cannot get it working.


Do While I <= 50
round(cells(I,3).value,2)
I = I + 1
Loop

or

Do While I <= 50
round(cells(I,3),2)
I = I + 1
Loop

And I have tried several other variations.....but I cannot get anything to
work.

Thanks,

Pete

 

[petedacook]

I apologize.......I see this was answered.....I have been having trouble with
the forums lately.