| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Linear Mode
