date as "mmm dd, yyyy" in the header in excel

[Guest]

I want to format the date in the header of my worksheet as "mmm dd, yyyy"
Thanks

 

[David McRitchie]

See http://www.mvps.org/dmcritchie/excel/pathname.htm

Since this is not a programming group:
File, Page setup, header/footer, date icon to left of clock
but that produces your short date from your Regional Setting
in the control panel.

I have Excel 2000, I don't know about later versions but
you would need a macro to format date as you want.
ActiveSheet.PageSetup.RightHeader = Format(now(),"mmm dd, yyyy")
If you also want to spell out the day of the week also include ddd or dddd

Some examples under
Using Workbook_BeforePrint to automate printing of heading/footing (#beforeprint)
at http://www.mvps.org/dmcritchie/excel/pathname#beforeprint

 

[Guest]

Go to "Format Cells" by clicking Ctrl+1.
Then choose on tab "Number": "Custom". Now you can type your format in
"Type": "mmm dd, yyyy". By entering a date (like '01-03-05') it will appear
like "Mar 01, 2005".
Retman

 

[Mohamed Shafiee]

Hi,

You can't change the date formate in the header of your worksheet.
Try using a row at the top of your sheet. To do this click File -> Page
Setup -> Sheet -> Rows to repeat on top, and select the row to repeat.

Shafiee.