Darren,

Assuming the value is located at cell A-1, the formula is =roundup(A1,0)
Is this what you were looking for?

Darren wrote:
is it possible to round up a decimal number regardless of it's value?

Example:
45.01 shown as 46

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200905/1