LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
GillianHG
 
Posts: n/a
Default Format Drill to Details Table

Hi all,

Does anyone know how to format the drill to details table that comes up when
you double-click a pivot table report so that it generates using specific
formats? For example, if there are dates in the Pivot Table, have them
appear in a certain format or have numbers show as currency. The source data
is formatted so this occurs but when the pivot table drill to details sheet
appears, the formatting is completely different.

I have searched everywhere I can think of for an answer to this. Help would
be GREATLY appreciated!!

Thank you!
Gillian
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keep conditional format when "show pages" from Pivot table Angus Excel Discussion (Misc queries) 7 June 30th 05 01:33 PM
Pivot table formatting programmer123 Excel Discussion (Misc queries) 4 June 17th 05 12:29 AM
problems with printing format for excel table in Publisher 2003 Kris J. Excel Discussion (Misc queries) 2 June 13th 05 08:14 PM
Another Exciting Data Table Question!!!! xinekite Charts and Charting in Excel 1 May 29th 05 01:22 PM
Removing errors from a Pivot table Mighty Magpie Excel Discussion (Misc queries) 2 February 3rd 05 03:15 PM


All times are GMT +1. The time now is 01:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"