I would use a second worksheet filled with formulae like this

=ROUND(Sheet1!A1,0)

filled to the right and down as necessary.

Regards,
Stefi


€žAl€� ezt Ã*rta:

I'd like to reduce the values of a range of cells by say 25%, and then
roundup the resultant values.
paste special multiply (by 75%) gives me various values including
decimals, but now I need to round these up, and I'm doing this manually, cell
by cell, at the moment!

It's driving me nuts....any ideas?