Posted to microsoft.public.excel.worksheet.functions

Sammie

external usenet poster

Posts: 11

Format date in header

I use the date button to insert the date in the spreadsheet header &[Date] ,
and I want to change the format of the date from 1/15/2010 to January 15,
2010. How do I do that?

Alternatively, what's the format for 15-Jan-2010?

--
Thanks.
Sammie SBS 2003, OFFICE 2003, XP-PRO-SP3, IE7

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
Date format in header	Michael	Excel Discussion (Misc queries)	3	April 30th 09 08:08 PM
Format of Header Date	TomCat	Excel Discussion (Misc queries)	2	November 11th 07 04:28 PM
Format Header Date	TomCat	Excel Discussion (Misc queries)	4	November 11th 07 10:43 AM
Date format in Header	Dr. Sachin Wagh	Excel Discussion (Misc queries)	7	December 26th 05 10:33 AM
Date format in Header	Irma	Excel Discussion (Misc queries)	1	June 17th 05 08:26 AM

All times are GMT +1. The time now is 03:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us