ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Format Extracted Data from Pivot Table (https://www.excelbanter.com/excel-discussion-misc-queries/163551-format-extracted-data-pivot-table.html)

Martincito23

Format Extracted Data from Pivot Table
 
Hi!
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.

I will appreciate your help on this!

Thank you in advance!

Martin

Debra Dalgleish

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


Martincito23

Format Extracted Data from Pivot Table
 
Thank you for your reply, Debra!

"Debra Dalgleish" wrote:

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




All times are GMT +1. The time now is 08:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com