Pivot Table date format



The "data" worksheet has the correct date format -mm/dd/yy. There is no time

When in the pivot table worksheet the date is showing up as :00, :01,
:02...... What appears to be a truncated time format.

I have tried to set the date format in both the data worksheet and the pivot
table worksheet with no changes evident. The data worksheet will change but
this is not carried over to the pivot table worksheet.

Setting the format in the pivot table worksheet has no effect.

Any suggestions??




Hi Irene, I have just tried to reproduce the error that you are seeing in
EXCEL 2007 but all seems OK to me.

I set up a Custom Date format (mm/dd/yy) and applied it to both the
underlying data and the Pivot Table and both looked OK to me.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question