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

D

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
 
R

retman

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
 
M

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.
 
Top