Thread: Pivot Tables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MJEXCEL MJEXCEL is offline
external usenet poster
 
Posts: 1
Default Pivot Tables

When I created a pivot table it used to have selections for eg field "A" of
1,2,3,4,5,6,7,8,9 when i clicked on the field selection within the pivot
table...

Something happened to the formatting in the source data and now when I click
on Field 'A' it is showing date formatting 1/1/1900, 2/1/1900 etc etc

No matter what I do I can't get the pivot field selection to show the
numbers the way they are in the source data.

Can Anyone Help