This post shows how to use the TRUNC function in Excel. Use it to remove or truncate decimals, time from date-time format, etc. It is the opposite of Round.

Want to delete or truncate numbers to the left in Excel? Learning how to remove numbers in Excel from the left is a neat trick to automate subtracting unwanted digits.