Changing the format of a cell doesn't change the value.

If your data is in A2:A99, then try this in two empty cells:

=counta(a2:a99)
and
=count(a2:a99)

=counta() will count the number of cells that have something in them.
=count() will count the number of cells that have a number in them.

If those formulas don't evaluate to the same thing (especially if =count()
returns a 0), then you have more to do to convert the values to real numbers.

Find an empty cell
edit|copy
Select the range to fix
Format as General
edit|paste special|values

This should convert those text numbers to number numbers.

Now back to your pivottable and refresh it.

Do you see the non-zero sum?

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

--

Dave Peterson