The easiest way to set a custom change date format in Excel is to start from an existing format close to what you want. pick the cells that contain dates, then right-click and select Format Cells. Select Custom in the Number Tab, then type 'dd-mmm-yyyy' in the Type text box, then click okay.