Many people answer of 3.14 if asked about the value of Pi.
In Excel or Google Spreadsheets, this value can be produced usingthe TRUNC function.
Where the number gets truncated is determined by the value of theNum_digitsargument.
Westend61 / Getty Images
Truncating Text Data
In addition to truncating numbers, it is also possible to truncate text data.
The decision where to truncate text data depends on the situation.
