You can effect some small changes in Regional and Language Settings in Control
Panel.

Change the short date format.

For major changes you would need VBA code.

Sub date_footer()
ActiveSheet.PageSetup.RightFooter = Format(Now, "yyyy-mmm-dd hh:mm:ss")
End Sub


Gord Dibben MS Excel MVP

On Mon, 7 Jan 2008 12:10:02 -0800, xanderkim
wrote:

The format is taken from your Regional Setting (found in Windows Control
Panel)
To override, use a macro such as
Sub MakeDate()
ActiveSheet.PageSetup.LeftFooter = Format(Date, "dd-mmm-yy")
End Sub
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"xanderkim" wrote in message
...