Hi Paul,

I did what you described and it worked - for some. The funny part is within
the same table, some of the dates could be changed to the format I wanted
(which is something like 23-Jun, instead of 7/23/2008) but some would turn
back to the original format (mm/dd/yyyy) upon refresh.

Now my column looks like this (see the table below) and I don't know nor
understand why it is so. This will happen after I refresh the table.
PRIMARY_FINALDUEDATE
29-May
30-May
27-Jun
5/29/2008
2-Jun
5/29/2008
5/29/2008

Please help...
Karen


"Paulw2k" wrote:

> Hi Jean-Marie,
>
> You don't say which version of Excel you are using, because the pivot-tables
> have change quite a bit between
> '97 and 2003. I am using the XP version and you can certainly customize the
> formatting for particular cells,such as Totals.
> Once you have your table constructed, select the cell(s) you want to format
> and right-click with your mouse and select
> "Format cells..." from the pop-up menu. Format the cells in the way you
> want and that is it. The (total) cells will remain like that
> after updating. Note also that you can set the number-formatting for the
> whole field the cell is part of, if you choose "Field settings..." from the
> same pop-up menu.
>
>
> Regards
>
> Paul
>
>
>
>
>
>
>
>
>
> "Jean-Marie" <Jean-Marie@discussions.microsoft.com> wrote in message
> news:2BF2BB3E-292E-4CE9-A3A2-1EAE90DF7BE0@microsoft.com...
> > Hi all!
> > I have a pivot table in my worbook with some customized formatting (totals
> > in bold, borderwidth, ....)
> > My problem is when I refresh the table I loose the formatting. Can
> > somebody
> > help me understand why? Is there any way that I can set the fomatting once
> > for all?
> >
> > Many thanks
> >
> > Jean-Marie.
>
>
>