Excel - pivot table - how do i format cells with data mm/dd/yyyy .

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

Dave

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

-----
XL2003
Regards

William
[email protected]


"Dave" <[email protected]> wrote in message
news:[email protected]...
>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