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

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...me#beforeprint
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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

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

"FemOkie" wrote:

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

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.


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