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