Robert
I have not been able to change that default. Perhaps someone else will jump
in.
A macro can be used.
Sub PathInFooter()
ActiveSheet.PageSetup.RightFooter = ActiveWorkbook.FullName & " " & _
ActiveSheet.Name & " " & Application.UserName & _
" " & Format(Now(), "h:mm:ss AM/PM")
End Sub
To just enter the time in the footer.......
Sub TimeFooter()
ActiveSheet.PageSetup.RightFooter = Format(Now(), "h:mm:ss AM/PM")
End Sub
Gord Dibben Excel MVP
>How do I display hh:mm:ss in a footer? Currently
>&[time] displays hh:mm