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?