Do you want to retain the unrounded value in the cell and only see the
rounded number?
Select the cells with any combination of mouse use and Ctrl and/or
Shift keys, then run this macro (having chosen which of the two lines
should be uncommented-out):Sub blah()
For Each cll In Selection.Cells
'cll.Value = Round(cll.Value, 2)'for actual rounding, OR:
cll.NumberFormat = "0.00" 'to see rounded versions
Next cll
End Sub
--
p45cal
*p45cal*
------------------------------------------------------------------------
p45cal's Profile:
http://www.thecodecage.com/forumz/member.php?userid=558
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=119276