Hi Joe

Hover your cursor above Date until you see a solid black downward pointing
arrowClickall of your dates will be selectedright clickFormat
CellsAlignmentCentre across SelectionOK.

If you do this correctly, your Date field will be formatted as such, and as
you add or delete dates form the PT, they will all be formatted as you wish

--
Regards
Roger Govier

"Joe" wrote in message
...
I have a pivot table where the column labels are the event date. There
can
be more / less event dates based on the range of data selected. Under the
column label for each date will be a sales count, a sales $ and a cost $
value.

How can I get the date to "Center Across Selection" of the 3 values when I
never know how many sets of data I will have?

__________ Information from ESET Smart Security, version of virus
signature database 4520 (20091018) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4520 (20091018) __________

The message was checked by ESET Smart Security.

http://www.eset.com