If you don't want to format to 2 decimal places for appearance and need the
value actually rounded, you can use this macro to add the ROUND function to all
cells in place.

Sub RoundAdd()
Dim myStr As String
Dim cel As Range
For Each cel In Selection
If cel.HasFormula = True Then
If Not cel.Formula Like "=ROUND(*" Then
myStr = Right(cel.Formula, Len(cel.Formula) - 1)
cel.Value = "=ROUND(" & myStr & ",2)"
End If
End If
Next
End Sub


Gord

On Fri, 8 Jun 2007 11:39:02 -0700, Hershey
wrote:

I have a formula in place, my result appears as 1.746724891, i'd like an auto
rounded # to appear w/out interfereing w/the formula already in place.
How do I do this?