I am working with a Pivot Table whose information comes from a two columns of
data that has been assembled from data copied and pasted from other sheets.
Unless I retype all the data, it only shows zeros when sum is selected from
field settings.

I need a way to get it to sum without retyping or at least to know why it
will not sum the numbers.

Thanks