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.