Posted to microsoft.public.excel.misc

TomCat

external usenet poster

Posts: 34

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Format of Header Date	TomCat	Excel Discussion (Misc queries)	2	November 11th 07 04:28 PM
Date format in Header	Dr. Sachin Wagh	Excel Discussion (Misc queries)	7	December 26th 05 10:33 AM
Date Format in Custom Header	Radsri-	Excel Discussion (Misc queries)	2	September 7th 05 03:57 PM
Date format in Header	Irma	Excel Discussion (Misc queries)	1	June 17th 05 08:26 AM
format the "date" button for a header	sc11	Excel Discussion (Misc queries)	1	May 12th 05 03:48 AM

All times are GMT +1. The time now is 05:03 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us