>You can force truncation using the FLOOR() function.

Careful, remember, Floor() rounds down to the next integer, and Cieling() of course rounds up, so Floor(nNum * 10) / 10 on -2.55 gives -2.6, thats not good. You'd have to use Floor(nNum * -10) / -10 or better yet, just Int(nNum * 10) / 10