&[Date] format modification in custom header

[Han Zomerdijk]

I'm using summary spreadsheets for miscellanious types of cash (Checks, ACH, Wires, etc).
We are switching to digital storage. Hence, I need a standard header on all forms, to provide consistency in the scanning process. I want to include the date in YYYY,MM,DD format, but have not found a way to modify the &[Date] function in the header.

 

[mathchick]

I believe you need VBA for this. Microsoft's help lists's the code on their website here

 

[smiths87]

Han,
You can do this pretty easily with VBA. Just type the below code in a module and run it. Format will be changed to whatever you specify in the "format" assignment on the right hand of the equation for whichever header position you specify. In this example it is "YYYY MM D" for the left header. Hope that helps.

Sub chghead()
ActiveSheet.PageSetup.LeftHeader = Format(Now, "yyyy mm d")
End Sub

 

[Han Zomerdijk]

Thanks for your quick response