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