Glad that it helped and all four of us Sandy's thank you for the feedback
<g

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Wayne Knazek via OfficeKB.com" <u26683@uwe wrote in message
news:81108cf335334@uwe...
Ya know, that's what I get for believing Microsoft! According to THEIR
definition . . .

"Truncates a number to an integer by removing the fractional part of the
number."

Their example shows using trunc with a number like 8.99. The result was
8.

That's why I added the note at the beginning of my post saying trunc was
not
the correct function!

Good grief. Thanks guys.

Anyone got an idea for the #2 question in my post?

--
Message posted via http://www.officekb.com