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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)
 
You must log in or register to reply here.

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

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Splitting dd/mm/yyyy hh:mm 2
Pivot Table sorts date as Alpha, not as Date 6
Peculiar default cell format 1
Converting mm/dd/yyyy to yyyy/mm/dd 6
converting dd/mm/yy to mm/dd/yyyy 3
Excel is seeing the date as dd/mm/yyyy 4
Pivot Table Date Format Question 6

Back
Top