Rounding 2 decimal Places

  • Thread starter Thread starter petedacook
  • Start date Start date
P

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
 
I apologize.......I see this was answered.....I have been having trouble with
the forums lately.
 
Back
Top