Dates and days of the week
 

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.

Dates and days of the week
 

What Excel really thinks is in that cell is the number 39813 - how it
is displayed is all down to the formatting applied to that cell.

In a helper column you can use this formula:

=TEXT(B3,"dddd")

to show the full day, and then copy this down. Then use this column
for your PT.

Hope this helps.

Pete

On Feb 4, 4:54*pm, MJ wrote:
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. *

Dates and days of the week
 

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.

Dates and days of the week
 

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.