Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
I am having trouble keeping numbers formatted in a Pivot Table | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |