View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Format Extracted Data from Pivot Table

There's no setting you can change to automatically format the extracted
data. You can manually or programmatically format it after it's been
extracted.

Martincito23 wrote:
Is there a way to format extracted data from pivot?

I have created a pivot table, and by double clicking on its cells, I can
obtain the details behind that information. The problem I'm having is that
that information is not showing up with the format I need.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html