facethemusic
New Member
- Joined
- May 30, 2007
- Messages
- 9
This has been bugging me for quite some time in excel....
when using pivot tables I tend to lose any formatting that the colums have when the data is refreshed or I use any of the drop down arrows to isolate a selection.
My time column for example I need in h:mm AM/PM format, but this is lost when I filter the pivot table.
any ideas? ... thanks.
when using pivot tables I tend to lose any formatting that the colums have when the data is refreshed or I use any of the drop down arrows to isolate a selection.
My time column for example I need in h:mm AM/PM format, but this is lost when I filter the pivot table.
any ideas? ... thanks.