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

I have a monthly spreadsheet in which I have to change the date in the header
each month. I want to do this automatically so I use the &[Date] feature but
it gives me a format like: 11-11-07.

I would like it to show November 2007.

How can I do this?

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