pivot table
 

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

pivot table
 

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