Change Date Separator

[mrsogmax76]

Is there a way to change a date format from DD.MM.YYYY to DD/MM/YYYY in excel without using the Regional and Language Options feature? Thank you.

[daddylonglegs]

You can set either one of those as a custom format

Format > Cells > Number > Custom > then type or paste required format in the box

[mrsogmax76]

Is there a macro, that would automatically do this for my UK staff, instead of them having to manually format the cells?