Whenever I set a date in the footer of Excel 2007, I get the SAME type of
format, i.e. "mm/dd/yyyy". The machine shows something like, say, "10/9/2007".

I want to change this to show soething like: "Tuesday, October 9, 2007"

Or evef, : "Tue, Oct 09, 2007".

How can I get this done ?