Select the cells you would like to modify and run this one-line macro:

Sub shifty()
For Each r In Selection
r.Value = Application.WorksheetFunction.RoundUp(r.Value, 0)
Next
End Sub

--
Gary''s Student - gsnu200762


"shifty" wrote:

If i have a set of number in a column is is pobbible to somehow use the
rondup function on that column with out having to put the answers into
another column?