Forum Discussion
Solved
How to change date format in Excel footer
I am creating a template for a Spanish project. In Spanish, the dates are formatted dd/mm/yyyy. How can I change the format in my footer ? The current entry is: Actualizado &[Date] Thi...
- I finally found a way to do this! I'll post the information here for anyone else looking for a way to accomplish this. It is from this article.
https://www.extendoffice.com/documents/excel/4266-excel-format-date-in-header.html
I created a 3 line VB script:
Sub add_date_footer()
ActiveSheet.PageSetup.LeftFooter = Format(Date, "dd-mm-yyyy")
End Sub
When I ran it, it changed the date in my footer from mm/dd/yyyy to dd/mm/yyyy.
Thanks for all the suggestions.
doh! sorry. did you try your original and just change the format?
https://support.microsoft.com/en-us/office/format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db95123d273e
https://support.microsoft.com/en-us/office/format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db95123d273e
I finally found a way to do this! I'll post the information here for anyone else looking for a way to accomplish this. It is from this article.
https://www.extendoffice.com/documents/excel/4266-excel-format-date-in-header.html
I created a 3 line VB script:
Sub add_date_footer()
ActiveSheet.PageSetup.LeftFooter = Format(Date, "dd-mm-yyyy")
End Sub
When I ran it, it changed the date in my footer from mm/dd/yyyy to dd/mm/yyyy.
Thanks for all the suggestions.
https://www.extendoffice.com/documents/excel/4266-excel-format-date-in-header.html
I created a 3 line VB script:
Sub add_date_footer()
ActiveSheet.PageSetup.LeftFooter = Format(Date, "dd-mm-yyyy")
End Sub
When I ran it, it changed the date in my footer from mm/dd/yyyy to dd/mm/yyyy.
Thanks for all the suggestions.