Triming a number

K

Keith

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?
 
Top