Why do pivot tables not read numbers that are copied and pasted
 

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

Excel is seeing the numbers as text. There are some techniques here that
you can use to convert the text to numbers, so they can be summed in the
pivot table:

http://www.contextures.com/xlDataEntry03.html

B_4j wrote:
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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html