Hi,

Try the following formulae:

=FLOOR(A1,1)
=ROUNDDOWN(A1,0)
=INT(A1)
=TRUNC(A1,0)

Regards,
KL


"trimatt" wrote in message
...
I do not want my numbers rounded up. I would like them to round down if
they
are a decimal of .5 or higher. Can this be done. If so, how?

Thanks for you help