SOLVED

Excel 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-1927451%22%20slang%3D%22fr-FR%22%3E2016%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1927451%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20post%20a%20long-form%20date%20in%20the%20footnote.%20This%20date%20was%20originally%20inserted%20by%20the%20Date%20button%20in%20Excel%202016.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1927451%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1927520%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1927520%22%20slang%3D%22en-US%22%3E%3CP%3EBonjour%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F880199%22%20target%3D%22_blank%22%3E%40Patricia_Bgu%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUne%20des%20options%20est%20d'utiliser%20la%20macro%20suivante%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ESub%20add_date_header()%0AActiveSheet.PageSetup.CenterFooter%20%3D%20Format(Date%2C%20%22mmmm%20dd%2C%20yyyy%22)%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EVous%20pouvez%20changer%20%22CenterFooter%22%20pour%20%22RightFooter%22%20ou%20%22LeftFooter%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Bonjour,

 

Je souhaiterais afficher dans le pied de page une date en format date longue. Cette date a été au départ insérer par le bouton Date du pied de page dans Excel 2016. 

 

Merci.

2 Replies
Best Response confirmed by Patricia_Bgu (New Contributor)
Solution

Bonjour @Patricia_Bgu,

 

Une des options est d'utiliser la macro suivante:

Sub add_date_header()
ActiveSheet.PageSetup.CenterFooter = Format(Date, "mmmm dd, yyyy")
End Sub

Vous pouvez changer "CenterFooter" pour "RightFooter" ou "LeftFooter".

@Bennadeau 

 

Merci beaucoup!