A VBA macro if you want to go that route.
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 & "," & "0" & ")"
'alter the "0" to your choice of decimal places
End If
End If
Next
End Sub
Gord Dibben Excel MVP
