Sub Arrondir()
Dim n%, ncol%, t, i&, j%, x$
n = 1 '2ème argument de la fonction Excel ARRONDI, à adapter
With ActiveSheet.UsedRange
ncol = .Columns.Count
t = .Resize(, ncol + 1).Formula 'au moins 2 éléments
For i = 1 To UBound(t)
For j = 1 To ncol
x = t(i, j)
If Left(x, 1) <> "=" Then If IsNumeric(Evaluate(x)) Then t(i, j) = Application.Round(Val(x), n)
Next j, i
.Formula = t
End With
End Sub