A macro?

Sub roundto()
For Each c In Range("c2:c12")
If IsNumeric(c) Then c.Value = Round(c / 5, 0) * 5
Next
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lisa" wrote in message
...
I need to round a group of numbers to the nearest 5...like 63 would be 65,
68
would be 70, 51 would be 50, etc. Is there a formula for this?