Triming a number
I have a list of numbers that I want to pull into a pivot table.
Unfortunately the numbers are all in the format of 1.253333333333333333333
or 12.24588888
If I format the cells to only show 2 decimal places they look fine but the
pivot table shows the full values.
How can I trim the values to just the 2 decimal places?
|