View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mj mj is offline
external usenet poster
 
Posts: 78
Default 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.