pivot table

[JC]

When I create a pivot table, all my data shows up as "1" in the table. I
can't figure out why and would love some help. Thanks

 

[Debra Dalgleish]

The numbers in the source data may be text, instead of numbers. To
convert them to real numbers, you can use one of the techniques shown here:

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