Dave

Untested, but could you not group your dates into "Days"
--

-----
XL2003
Regards

William



"Dave" wrote in message
...
i have base data in the format of mmddyyyy hhmmss that I'm putting into a
pivot table. How can I format the Pivot Table fields to show mmdd so only
one entry shows for a given day? 'format\cell\mmdd' does not work