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 he

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


JC wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html