Back to all functions

This lesson will show two ways to cut decimals from a number in Excel, the INT and TRUNC function.
INT, short for Integer, rounds the number down to the nearest whole number. We’ll write Equals, INT, and select the number. We’ll then copy down.
As we can see, if we had simply shown fewer decimal places, the number would have been rounded up, but the INT function simply cuts off all of the decimals in the number.
The TRUNC function, on the other hand, lets you choose how many decimals you want to remain.
We’ll write Equals, TRUNC, select the number, and write how many decimal places we want to have left after the function has run, which for us will be two.
Copying down, we can see how each number now has two decimals remaining in the number.
In this lesson we have taken a look at two ways of chopping decimals off of a given number.

Popular courses

The Excel Functions Guide

Deepen and develop your Excel Functions skills

Learn how to efficiently manage databases, clear text in cells, and retrieve values from other tables. The course also walks...

Excel Essentials

Get a better understanding of the Excel workflow

Learn to feel more comfortable in Excel. This course will help quickly develop your knowledge in Excel. Excel Essentials is...

Contact us for assistance in finding right course

Excel for your profession

The Excel course for Procurement and Logistic professionals

Excel for professionals working within procurement and logisticians

In cooperation with organisations and professionals within the industry, Learnesy have developed an Excel course that is adapted to those...

Looking for something custom made? Contact us and we will make sure to meet your requirements.