Excel TRUNC Function - Reduce Decimals Places without Rounding

5 Jan 2012 ... Use the TRUNC function in Excel to shorten numbers by removing decimal places without rounding ...

spreadsheets.about.com