View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TomCat TomCat is offline
external usenet poster
 
Posts: 34
Default Format of Header Date

I have a monthly spreadsheet report in which I have to change the date in the
header each month before I publish it. I would like to avoid doing that by
having the header date change automatically. I used the &[Date] feature but
it formats the date 11-11-07.

I want the date formatted like: November 2007

Is it possible to do this?

Thanks...............TomCat