Select the range (all the cells) in the pivottable, then do the formatting just once.
Faulk wrote:
>
> In my raw data, I have field called Month and it's entered as 4/1/05
> but formatted as April-05. When I use this field to group data in a
> pivot table, the months appear as 4/1/05. How can I make them appear
> as April-05 without having to format each individual cell in the pivot
> table?
Re: column width in autoformatted pivot table ... characters to the cells to achieve the correct column width when the column ... Right-click a cell in the pivot table, ... Ensure that Preserve Formatting is turned on, and AutoFormat is turned off, then click OK ... (microsoft.public.excel.misc)
RE: Format PivotTable ... Let's say your pivot table is between cells A2:H26 (yest there will be some ... Now you have dynamic values and "0" where blank cells in a pivot are. ... When I refresh the table, ... I've tried changing the Preserve Formatting and the Autoformat Table and I ... (microsoft.public.excel.misc)
Re: Pivot Table formatting ... --Before formatting cells, use the selection feature to cells. ... From the Pivot toolbar, choose PivotTable>Select, ... and click on Enable Selection)... (microsoft.public.excel.misc)
Re: Pivot Table Formatting ... Before formatting cells, use the selection feature to select the cells. ... move the pointer to the top of a column in the pivot table. ... When the black arrow appears (like the one that appears when the pointer is over a column button), click to select the column in the pivot table. ... (microsoft.public.excel.misc)
Re: Formatting a pivot table ... What version of Excel are you using? ... These formatting options will work only if the pivot table layout is not changed by the end user. ... --Instead of selecting cells to format numbers, right-click the field button, and choose Field Settings. ... (microsoft.public.excel)
