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
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