Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I apologize.......I see this was answered.....I have been having trouble with
the forums lately. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rounding value from millions to decimal places | Excel Worksheet Functions | |||
rounding decimal places | Excel Discussion (Misc queries) | |||
Rounding to two even decimal places | Excel Worksheet Functions | |||
Rounding off decimal places | Excel Discussion (Misc queries) | |||
Decimal places and rounding up (or down) | New Users to Excel |