Does anyone know how to format &D or &T in Excel header or footer? I could use Format(Now, "yyyy/mm/dd HH:nn:ss") to get the format I wanted. But how do i do it with &D or &T?

migrated from stackoverflow.com Oct 13 '09 at 18:35

This question came from our site for professional and enthusiast programmers.


You can do this using VBA:

With ActiveSheet.PageSetup 
    .RightFooter = "Printed " & Format(Time, "hh:mm") & " - " & Format _ 
    (Date, "mmm dd yyyy") 'Todays Date
End With 

As per this Knowledge Base article: "These date and time formats are based on the Date and Time tabs in the Regional Settings Properties dialog box."

So you can change that setting, though that only solves the problem for the computer you're on. The other solution is to use JeffP's macro or a variant thereof.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.