Why not just insert a new colum with =roundup(a1,0). then
copy paste specialValues. then delete original colum.

Hit the record new macro button while you do this the
first time and you will havwe all the syntax for future
applications.

Pete

-----Original Message-----

I have a question. I have an excel files with numbers in
one column
(multiple rows). How do I round the numbers up in each
row without
doing it one by one?

Please help


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.