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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel - pivot table - how do i format cells with data mm/dd/yyyy . (https://www.excelbanter.com/excel-worksheet-functions/22494-excel-pivot-table-how-do-i-format-cells-data-mm-dd-yyyy.html)

Dave

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

William

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

All times are GMT +1. The time now is 07:27 PM.