Forum Discussion

Thomas625's avatar
Thomas625
Copper Contributor
Apr 06, 2020

Datumsformat in Fußzeile ändern (Excel Mac)

Ich möchte das Datumsformat in meiner Fußzeile ändern. Derzeit wird dieses im Kurzformat (z.B. 06.04.20) angezeigt, ich brauche das aber im Langformat (06.04.2020). Danke! LG Thomas

 

Excel on Mac

1 Reply

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    May 02, 2020

    Hi Thomas625

     

    Changing the formatting for header & footers can be done only with VBA as of now.

    the date format is based on your regional system settings.

    you can use the below code & run the same on the active workbook before printing the document.

     

    Sub ChangeFooterDateFormat()
    ActiveSheet.PageSetup.LeftFooter = Format(Date, "dd.mm.yyyy")
End Sub

     

    If you wish to display it to a different place in the header or footer, then change the part of the above code "LeftFooter" to any one of these [CenterHeader, CenterFooter, RightFooter, LeftHeader]

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

     

     

Resources