Select all the cell, enter the formula for the first cell in the formula
bar, then hit Ctrl-Enter..

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Robert" wrote in message
...
How can I apply the ROUNDUP formula to several cells with different
munbers
at the same time without having an error.