columns(5).numberformat = "#,###"

will give a rounded appearance - not sure what you actually want.



--
Regards,
Tom Ogilvy

"projectside" wrote in 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/