Question: how to change date format in excel in footer?
Answer: Go to file > page setup then select the header/footer tab. have selected. it to be "dd-mm-yy".