Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables
MJEXCEL;308422 Wrote: 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 Hi, have you tried right-clicking the field - Select Field settings - Select Numbers and Format as needed ? -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86224 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |