The TRUNC function is a useful tool for returning a truncated number based on an (optional) number of digits. For example, TRUNC (4) will return 4 and TRUNC (-3) returns -3.It is important to note that the TRUNC function does not round, it simply removes the fractional part of the number. In Microsoft Excel, the TRUNCATE () function can be used to truncate a number to a specified number of decimal places. This is especially useful when dealing with text data that needs to be shortened for easier display.
In this article, we will look at the easy steps to truncate a cell using the TRUNCATE () function. The TRUNCATE () function returns n decimal places truncated to d. If you omit d, n is truncated to 0 decimal places. If d is a negative number, the function truncates the number n to d digits to the left of the decimal point.
For example, if d is -2, the TRUNCATE () function will truncate two digits to the left of the decimal points. In addition to Excel, Oracle and PostgreSQL also provide the TRUNC () function which has the same functionality as the TRUNCATE () function. Truncation can also occur when a decimal number is typecast as an integer; it is truncated to zero decimal digits because integers cannot store non-integer real numbers. If you want to truncate characters in an entire column, you must ensure that you have all the text string to truncate in one column.
In mathematics and computer science, truncation limits the number of digits to the right of the decimal point. In this case, the truncation of a polynomial P to degree n can be defined as the sum of all P terms of degree n or less.