How to Delete Numbers after Decimal Point in Excel

This post will guide you how to remove decimals without rounding in Excel. How do I delete numbers after decimal point with a formula in the given cell in Excel.

Deleting Numbers after Decimal Point


Assuming that you have a list of data in range B1:B5, in which contain decimal values. And you want to remove all decimal without rounding for a given cell in Excel. You can use the TRUNC function to achieve the result. Like this:

=TRUNC(B1,0)

Type this formula into a blank cell and press Enter key on your keyboard, and then drag the AutoFill Handle over to other cells to apply this formula.

delete numbers after decimal point1

You can also use another formula based on the INT function to achieve the same result of deleting numbers after decimal point in Excel. Like this:

=INT(B1)

delete numbers after decimal point2

 

 

 

Related Posts

Extract date from multiple cells containing both date and time

As if you have got a cell containing date along with the time in the same cell and you want to extract the date into a separate cell, then for one or two cells, you can extract the date manually ...

How to Auto Fill Weekdays or Weekends in Excel

Sometimes we may want to enter a sequence of days in excel for some purpose, and we can press Ctrl+; to insert current date into cell, and then drag the cell down to attach following days into other cells, then ...

How to Stack Data from Multiple Columns into One Column in Excel

In previous article, I have shown you the method to split data from one long column to multiple columns by VBA and Index function. This time if we want to stack data from multiple columns to one column, how can ...

How to Calculate Retirement Date and Remaining Years refer to Birth Date in Excel

Every company has its own police about the retirement date for employees. Suppose employees will be retired from a certain age of 60, how can we calculate the retirement date for everyone base on their birthdays? Actually, there are several ...

How to List Only Whole Numbers From Decimal Numbers in Excel

This post will guide you how to filter only whole numbers from decimal numbers in a list in Excel. How do I filter cells with whole numbers or non-whole numbers in Excel. List Only Whole Numbers Assuming that you have ...

Sidebar