=ROUND(A1,2)
--
Gary''s Student
gsnu200703


"Keith" wrote:

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?