Question: how to set custom date format in excel 2010?
Answer: Select the cells you want to format. Press CTRL+1. In the Format Cells box, click the Number tab. In the Category list, click Date, and then choose a date format you want in Type. ...  Go back to the Category list, and choose Custom.