Try this:

=CEILING(A1,1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"hsaryfm" wrote in message
...
How to convert 0.1 to 1

or

5.11125 to 6.000