bbatson
New Member
- Joined
- Aug 22, 2006
- Messages
- 47
Hello - I am running Excel 2007, although this question probably also relates to prior versions of Excel. I have noticed that the "Number Format" button is only available for some fields within a pivot table. This can be frustrating because, for the columns that you cannot specify a format for, the user is forced to reformat after each drill of the pivot table.
I cannot identify a rhyme or reason as to when the Number Format button is available. Can anyone provide any insight on this?
Many thanks,
Brian
I cannot identify a rhyme or reason as to when the Number Format button is available. Can anyone provide any insight on this?
Many thanks,
Brian