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.