Question: how to change date format in ms excel 2007?
Answer: 1Enter a date into a cell. Depending on what you type, Excel probably displays the date in a different format. 2From the Home tab, click the Number dialog box launcher. The Format Cells dialog box appears. ...  3Click Date in the Category list. ...  4Select a format for the selected cells. ...  5Click OK.