PIVOT Display is WRONG

  • Thread starter Thread starter DOUG
  • Start date Start date
D

DOUG

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.
 
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...
 
Jim: It was "general" which I have reformatted to numbers, but it did not
help. I shall try adjusting the decimals.

DOUG
 
Jim: Your comment jogged my memory. I tried multiplying the original column
by 1, then pasted the result back into the original column - and it worked!

Thank you very much.

Sincerely,
DOUG ECKERT
 
Back
Top