Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table format changes when data is refreshed | Excel Discussion (Misc queries) | |||
Pivot Table Default data to format other than General | Excel Discussion (Misc queries) | |||
how do I format data into columns using a pivot table report? | Excel Discussion (Misc queries) | |||
Pivot table format changes if value of source data is null | Excel Discussion (Misc queries) | |||
Excel - pivot table - how do i format cells with data mm/dd/yyyy . | Excel Worksheet Functions |