Question: how to change long date format in excel?
Answer: Select the cells you want to format.
Choose the HOME, then the number format drop-down menu (shown at right) in the NUMBER GROUP.
[Select] SHORT DATE or LONG DATE, depending on your preference for a numerical date (ie. 2/27/2012) or a written date (ie.