How do I change date format in excel footer

N

nunee

the format dd-mm-yy would be more convenient for me and my colleagues. is
there a way to do that? thank you.
 
F

Frank Kabel

Hi
only possible with vBA directly inserting the date in the required
format. There's no build-.in way to achieve this
 
G

Gord Dibben

If you change your Windows>Control Panel>Regional and Language Settings Short
Date format to dd-mm-yy Excel will use that setting.

Note: this would be a global setting for Short Date.

Otherwise, Frank's suggestion re: VBA is the way to go.

Gord Dibben Excel MVP
 
Top