Try this:

=ROUNDUP(A1,0)

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Darren" wrote:

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

Example:
45.01 shown as 46