Dave Peterson: Both COUNTA and COUNT returned the number one. Pasting the
value and/or format of the blank, general cell did not change the numbers in
the base table or in the pivot table. I did revert to the old trick of
multiplying the numbers in the base table by 1, but that did not work either.
I am open to ideas. I do have a sample of a very similar pivot table I
completed a couple of months ago that is correct, but all of the underlying
formatting appears to be the same. (How frustrating)!

DOUG

"DOUG" wrote:

My pivot table displays zeros instead of numbers. I have tried re-formatting
the numbers to "General" and "Number" and "Text". I have tried changing
"Count" to "Sum". I can see the correct numbers in the spreadsheet but not
in the pivot table. Please advise.

DOUG ECKERT