Summary

To get just the decimal part of a number, you can use a formula based on the TRUNC function. In the example shown, the formula in cell C6 is:

=B6-TRUNC(B6)

Generic formula

=number-TRUNC(number)

Explanation

Excel contains a number of rounding functions. Two of these functions, the INT function and the TRUNC function will return the integer portion of a number that contains a decimal value.

The INT function behaves a bit differently with negative values, so in this example we are using the TRUNC function. The TRUNC function simply truncates (i.e. removes) decimal values if they exist – it doesn't do any rounding.

In the example shown, cell C6 contains this formula:

=B6-TRUNC(B6)

The TRUNC function returns the integer portion of the number which is then subtracted from the original value. The result is the decimal portion of the number.

If the original number is an integer to begin with, the result of this formula is zero.

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.

Get the Lifetime Pass

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Related formulas

Excel Get integer part of a number

Get integer part of a number

To remove the decimal part of a number and return only the integer portion, you can use the TRUNC function to slice off the decimal. In the example, cell C6 contains this formula: =TRUNC(B6) The TRUNC function simply truncates (i.e. removes) numbers; it doesn't not round at all.