Uh - that's: your cell is CUSTOM formatted...
Right-click the appropriate field header & select Format Cells (XL 2007)
- then select Custom. Check out OLH for date formats, but the formats
quoted below should give you a clue



"Bob Alhat" wrote in message
...
Your cell is formatted as "dddd, mmmm d, yyyy" or"dddd, mmmm dd, yyyy".
The field in the pivot table needs to be formatted the similarly.
Right-click the appropriate field header & select Format Cells (XL 2007)

HTH
Bob


"MJ" wrote in message
...
In cell B3 it reads Wednesday, December 31, 2008 but if I put my cursor
in
the cell it shows only 12/31/2008 as the contents. I want a pivot table
that
shows day of the week as well as date. With this formatting it only
shows
the date not the day of the week. I have tried formatting as date, text,
and
general and cannot get the info showing to really be what Excel thinks is
in
the cell.