View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Todd1
 
Posts: n/a
Default Pivot tables with zero/null values

It will not change. I try formating the column, and the pivot table and
cannot get it to move off the 3-jan

"David Biddulph" wrote:

"Todd1" wrote in message
...
Debra:

When I do this, all the dates show up as 2-Jan 3-Jan 4-Jan. I try
formatting the numbers and they will not format to "Wednesday, January 2".
Any suggestions?


Format Cells/ Custom:
dddd, mmmm d
--
David Biddulph