The values that you are aggregating... Are they numbers or text that looks
like numbers. Try formatting the source data with more decimal point or such
to see what you really have. If that is the case then it is just a matter of
coercing the text to numbers which we can help you with...
--
HTH...

Jim Thomlinson


"DOUG" wrote:

My pivot table will display only zeros (if formatted to SUM) or ones (if
formatted to COUNT). It will not display the values from the spreadsheet. I
have tried every formatting trick I can imagine. Suggestions?

DOUG ECKERT

PS, I prepared over a dozen other pivot tables today without this problem.