>Hi,
>
>What about:
>
>
Round(CSng(nValue)+0.5)
>
>Just 2 cents.
Well, if nValue is 4.0, that still returns 5.0. Which, I would assume, is not the desired result.
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell
