1. Computing
Ted French

Truncate Numbers in Excel

By February 1, 2013

Follow me on:

The TRUNC function is another of Excel's rounding functions - except that it does no rounding.

What is does is truncate or chop off the decimal portion of a number leaving only the whole number.

This is very close to the INT function except that INT rounds the remaining whole number down, while TRUNC just leaves the remaining number as is.

To find out more about this non-rounding rounding function, read the short tutorial on the Excel TRUNC Function.

More Rounding Number Functions
February 3, 2013 at 9:23 am
(1) Ankit Kaul Machama says:

Hi Ted, its my first visit here. I really liked this article but I have a question that: will Trunc function also work on negative numbers?

Also, I tried to use this function in Excel VBA but I couldn’t find it there (even under the WorksheetFunction). Is it absent in VBA?

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.