Take a look at =rounddown() in excel's help.

Ace wrote:

How do I get "1.9" to show as "1" instead of "2".

Excel always rounds the number to nearest integer.

Is there anyway of Truncating it. Can you use the TRUNC formula in a format
so something?

--

Dave Peterson