Excel Trunc

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… read more »

Extract Date from a Date and Time

This post will guide you how to extract date part from a date with time values in Excel. How do I remove time part from a date in Excel. How to get only date part from the date with time values via Format cells feature or Excel function. How to extract date from a date… read more »

Excel TRUNC Function

This post will guide you how to use Excel TRUNC function with syntax and examples in Microsoft excel. Description The Excel TRUNC function truncates a number to an integer by removing the fractional part of the number. So this function returns a truncated number based on a given number of digits in Excel. The TRUNC… read more »