How to Auto-Format the Date in MS Excel. ... When you see the formatting you want, click the "OK" button to apply it and close the dialog box. Advertisement. Article continues below this ad.