Round multiple cells at one time?

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Daily Time Sheets with Rounding 1
Rounding Time to Nearest 5 Minutes 1
Rounding in the Same Cell 2
How do I make a cell round to another cell? 5
Rounding 2
Round up 4
How to round down a value to the inferior multiple of 5 3
Excel VBA to match positive and negative transactions 3

Back
Top