Bernard Liengme wrote:
Can an old academic have a good moan?
The round function (and formatting) alter the 'number of
decimal places' NOT the 'number of significant digits'.

And while we are nitpicking, I hasten to point out that the
ROUND() function does not "truncate". It, ah, rounds.
ROUND(4.45,1) is 4.5. TRUNC(4.45,1) is 4.4.


Date: Sun, 13 Nov 2005 15:32:12 -0000
Subject: An Inquirey on the Round function

It truncates the 'actual' value, formatting truncates the display only
[....]
Nick Hodge
Microsoft MVP - Excel