Rounding 2 decimal Places

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
 
P

petedacook

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top