Bob,

When I do that every cell from the multiple choice turns into the same
value, eventhough I got different values. Do you have anything else on mind.

"Bob Phillips" wrote:

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.